Skip to Content

Saving Analysis for Office workbook static/without data source

A client of ours wants to save an Analysis workbook locally with values and formatting only (without a data source). Is there any way to do this automatically or at least end user friendly? Right now we do it manually by copying all sheets to an empty workbook, but we feel there should be a simpler way to do this.

Any suggestions will be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 31 at 11:03 AM

    Hello - have you considered workbook/style templates?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tammy

      I am not sure what you mean by that. Maybe my question wasn't clear enough. Basically what I need to do is save a workbook as is from the server to my desktop. I don't want it to have any data sources in it after I save it but I do want the values(without formulas) and formatting to remain the same.

  • Jan 31 at 01:00 PM

    Hello Enis - please see the SAP Help https://help.sap.com/viewer/ca9c58444d64420d99d6c136a3207632/2.6.1.0/en-US/f2723ab36c9b1014bf2c9a7eb0e91070.html - maybe the "remove data before saving" option will meet your requirements.

    Add comment
    10|10000 characters needed characters exceeded

    • Unfortunately this is not the solution I am looking for. Our client needs the data but static - disconnected from all data sources. I will leave the question open in case someone has a similar requirement or a solution. Thank you for your effort.