EPM Report Refreshed through VBA

[former_member313059]

Hello Experts

We are running Netweaver Version 10.0, SP21 on MS Office 2010.

When a workbook is opened and has one or more EPM Reports refreshed through VBA using the EPMObj.RefreshReportDataOnly code, the Excel session becomes unstable and regularly crashes.

If however the EPM Reports are first refreshed using EPMObj.RefreshActiveSheetcode, then EPMObj.RefreshReportDataOnly will subsequently work in a stable manner.

Is this behaviour standard and expected?

...or

Should the EPMObj.RefreshReportDataOnlycode work correctly without the EPMObj.RefreshActiveSheet code having been executed first?

(Please note that all Refreshes are performed through VBA and not the EPM ribbon).

Please share any thoughts or experiences of this with us.

Thanks

Jo

[former_member186338]

Hi Jo,

I do not think that there is any difference between RefreshReportDataOnly and RefreshActiveSheet related to worksheet stability. I suspect you have some general issues with your VBA code...

Vadim

[Former Member]

Hello Caine,

What you want to execute first

RefreshReportDataOnly   OR  RefreshActiveSheet   ??

[Former Member]

Use any one option and execute your code !

Then refresh your excel using that macro will see.