Skip to Content
author's profile photo Former Member
Former Member

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.

~Dilkins

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 15, 2015 at 02:28 PM

    Hi Andrew,

    Which SP you are using ?

    Have checked compatibility other software component like OS, BIT, MS Office version & Bit,?

    Shrikant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 16, 2015 at 06:35 AM

    Hi Andrew,

    Which version of Excel? 32 or 64 bit?

    How much RAM does the PC/laptop have?

    Slower performance is mainly due to your PC's limitation.

    Also is there any VB in those reports?

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.