cancel
Showing results for 
Search instead for 
Did you mean: 

Analysis for Office make it a "normal" workbook

benjamin_emde
Explorer
0 Kudos

Hello,

we want to make an Analysis for Office workbook (with embedded queries) a "normal" workbook that allows automatic saving (since there are numerous further spreadsheets within the workbook that contain data coming not from a query). Steps we have taken so far:

- components-tab -> deletion of all Analysis for Office elements

- in VBA-editor there exists a spreadsheet "_com.sap.ip.bi.xl.hiddensheet" with visibility "xlsheetveryhidden". This spreadsheet we deleted as well but unfortunately it is added again immediatly.

So automatic saving is not possible so far ... Any ideas what we can do in order to make automatic saving possible?

Thank you in advance and kind regards,

Benjamin

Accepted Solutions (0)

Answers (0)