Question Re: How to prevent refreshing saved SAP Analysis Workbook using VBA code. in Technology Q&A

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

former_member194898 — Wed, 13 Jul 2022 14:34:44 GMT

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

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

VijayetaSharma — Wed, 13 Jul 2022 19:01:19 GMT

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-part-2/

Thanks,

Vijayeta

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

former_member194898 — Wed, 13 Jul 2022 21:08:24 GMT

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