How to change the order in which multiple reports refresh on a worksheet

[Former Member]

Is there a way to change the order that multiple reports will refresh is on the same worksheet?   For example, I have a report that returns the CostObject of the context.  Second report uses that CostObject in an epmdimensionoverride.  If the order in which the reports refresh can be controlled, the sequence will work.

[Former Member]

Here is how to do it

https://scn.sap.com/thread/3619898#15377732

[Former Member]

Thank you for the response.   We really don't want to us macros as they may cause problems for users on difference versions of Excel.  Also, want don't want to use EPM formulas since they update AFTER the report refreshes.

[gajendra_moond]

Hi Mike

The reports will refresh in the same order in which you have created. Let us say you have 3 reports in the same worksheet. In the report editor:

Report 1 will be named as "Default Report"

Report 2 will be named as "Report 001"

Report 3 will be named as "Report 002"

If you create your reports in this order, they will refresh in the same order. Default then 001 and then 002.

[Former Member]

Hi Mike,

Try using macro with EPM.RefreshActiveReport.

Thanks

Regards,

Prashant