How to prevent refreshing saved SAP Analysis Workbook using VBA code.

[former_member194898]

Hi,

How to prevent refreshing saved Analysis for Office Workbook after they are being opened (using VBA).

I suppose there is a way to turn off via VBA options "Refresh workbook on opening" and "Force prompts for refreshing" in Workbook_BeforeSave section or sth like this.

Regards, Leszek

[VijayetaSharma]

Hi leslaw.piwowarski,

These are old blog posts, though they are still applicable with newer versions of AO.

https://blogs.sap.com/2016/12/18/automated-updating-of-data-in-excel-files-bex-ao-via-vbavbscript/

https://blogs.sap.com/2017/01/15/automated-updating-of-bw-data-in-excel-files-bex-ao-via-vbavbscript...

Thanks,

Vijayeta

[former_member194898]

Hi vijayeta.sharma,

Thank you for your help but I don't see the explanation of my problem in those blogs.

Now, without using VBA, it works like this:

1. A user logs in and opens AfO workbook from the server,

2. The data is being refreshed automatically <- that's OK !

3. User turns off "Refresh workbook on opening" and "Force prompts for refreshing" and saves that workbook on the local disk.

It's importanf for the user to have a real archive workbook - without refreshing on opening. AfO workbooks after has been saved on the disk should act like an ordinary excel file. No login window and autorefreshing data should work after the AfO workbook is run from the local disk.

That's because I need to have a VBA code that works like someone turns off "Refresh workbook on opening" and "Force prompts for refreshing".

Regards. Leszek