SAP Knowledge Base Article - Public

3023607 - Uploading Analysis for Office workbooks on Google Drive

Symptom

You are uploading Analysis for Office workbooks on Google Drive to deliver to end users.
When you upload the file and just download the file, Analysis for Office will work as expected.
In case you open the workbook on Google Sheets and make any change on the workbook or the "automatically save" engine starts, the workbook will lose all connections configuration and you will no longer navigate, refresh and execute the workbook. (Analysis buttons will remains greyout).

Environment

  • Analysis for Office 2.x
  • Google Drive

Reproducing the Issue

Saving the workbook and upload it on Google Drive:

  • Create an Analysis for Office workbook
  • Save locally
  • Upload on the Google Drive

googledrive.png

 On this case, if you directly download the file and execute it locally, you will be able to execute, refresh and navigate on Analysis for Office workbook.

Opening the workbook on Google Sheet:

  • On drive, right click and open on Google Sheet

googlesheet.png

  • On this situation, Google sheets has an engine that AutoSave the sheet on drive. It will AutoSave for any small change:

saving.png

  • After the AutoSave, Google Sheet will overwrite the original workbook and will delete all the references to the data sources included in the file
  • If you download the file, Analysis for Office workbook will lose all connections configuration and you will no longer navigate, refresh and execute the workbook
  • One symptom observed is that the workbook appears with a new sheet with the name: _com.sap.ip.bi.xl.hiddensheet

newsheet.png

Cause

This is caused by the Google engine

Resolution

Analysis for Office works with google drive if not executed on googlesheet.
For the file executed on google sheet, google engine ovewrite the file and it will no longer works with Analysis for Office.
Do not change or open Analysis for Office workbooks on google sheets.

See Also

Keywords

_com.sap.ip.bi.xl.hiddensheet, google , drive, Analysis, Office , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions