Workbook Refresh Detecting EPM Functions

[Former Member]

I'm trying to understand how EPM processes a request to Refresh Workbook. I have a workbook with multiple tabs of EPMSCALEDATA formulas. When I click refresh, many times it has a message [sheet name]: Detecting EPM Functions. This message appears sometimes for several minutes on worksheets that do not contain any EPM formulas. Why would EPM take so long to detect EPM functions on a sheet with not EPM functions?

Separately, when clicking Refresh Workbook, depending on which sheet I am on, different sheets besides the one I refreshed on populate data, while others do not refresh and still have #RFR.

I've seen other forum posts from users with similar issues but I haven't seen a solution. Please do not tell me to convert my report to a static EPM pull. EPMSCALEDATA is a supported function and there ought to be a solution.

[former_member186338 · Accepted solution]

First - epmscaledata is supported function, but a very slow function in case of multiple cells.

Second - for each sheet please check in sheet options is it set as epm worksheet or not.

[Former Member · Accepted solution]

Thanks! Very helpful. For some reports I really don't think we're going to get away from EPMScaleData so I'm trying everything I can to speed up refresh times.

Could that setting (incorrectly set on non-EPM worksheets) have caused some excel sheets to refresh and others no when clicking Refresh Workbook?

[former_member186338 · Accepted solution]

If some worksheet is not set as epm worksheet then it will not be refreshed. But you have to create a test case and provide a detailed version info about bpc, epm and Excel