Issue with Workbook Refresh and EPM Function Limits

[Former Member]

Has anyone else run into issues with Workbook Refresh when there are multiple EPM Functions throughout the workbook? I'm working with a number of workbooks with 10+ tabs. The first few refresh fine. Depending on the workbook, at some point Refresh just stops working.

I know what the documentation says about using them sparingly, but sometimes we have to push the limits. Just wondering if anyone has figured out what critical mass for EPM functions is before functionality starts breaking down.

Laurie Whitney

[Former Member]

Hi Laurie,

Having large number of tabs would not stop the report form refreshing.  Please try refreshing individual worksheet and see the reports are refreshed.

Also check each report's connection which are not getting refreshed.

Regards,

Kalyan.