Same EPM Excel Report takes time to open and refresh on 1 system while it opens and refreshes faster on other system

[former_member339201]

Hi All ,

I am facing an issue where the EPM Excel Templates on SERVER ROOT FOLDER take time to open on 1 system . It also takes great amount of time to REFRESH . While on an another system the same Report opens rather quickly and refreshes also quickly .

Regards,
SHUBHAM

[Shrikant_Jadhav]

Hi Shubham,

Is the SP of EPM add in same for both system ?

Shrikant

[former_member339201]

Hi Shrikant ,

Yes it is same.

Shubham

[Former Member]

Hi Shubham,

Please observe physical memory usage in two different machines.

What is the configuration of two machine is it same or different?

[Shrikant_Jadhav]

Hi Shubham,

Try to clear metadata cache, temp file and check other compatibility like OS bit, MS Office version and Bit.

Shrikant 

[former_member339201]

Hi Shrikant ,

Could you please tell specific steps that you had taken or suggest what probably is the issue .I cleared the metacache and temp file earlier also ..

Regards,
SHUBHAM

[Former Member]

Hi Shubham,

Now day excel problems are due to some MS update.  Not sure but  have a look at below note.

2107965 - Issues in EPM Add-in after installing Microsoft updates