Analysis for Office Workbook Optimizer/Cleaner

[jml0mzx]

I am looking to optimize or clean-up a mass amount of end-user AO workbooks. I am seeking a tool or some code that can help facilitate the process, rather than having to do this manually. Particularly, I'm looking for something that can:

1. Remove data sources that do not have crosstabs (from users deleting the workbook sheets) causing the 'unused' data sources to run every time it is refreshed/opened.

2. Merge variables

3. Remove unused excel styles

3. Remove invalid/hidden named ranges

There used to be an XLStyles tool available that helped with some of this but it is only available on the Microsoft Store and inaccessible to my organization.

Any ideas or help would be appreciated. I'm familiar some of the VBA functionality but it does not seem to facilitate this type of automation and I'm open to any suggestions.

[VijayetaSharma]

Hello john1234,,

Don't think you can achieve this via any available SAP API.

May be try script for couple of items above:

https://stackoverflow.com/questions/71112393/delete-worksheet-from-excel-workbook-using-powershell

Beside you can create enhancement request for AFO here as well:

https://influence.sap.com/sap/ino/#/campaign/889

Don't forget to up-vote and accept, if it helped. 🙂

Thanks,

Vijayeta