EPM Excel Addin Performance
EPM 10 SP 21 NW Version
We have a situation where , users are able to open and run report/input forms but if they open multiple workbooks each new report is getting slower and slower to refresh. If the new report is opened in a new excel then they work normally but that is not convenient for user.
Any thoughts or performance improvement suggestions? I am sure the excel process resource limits are coming into play but haven't faced such issues with other projects. I wonder if we are missing anything.