SAP Knowledge Base Article - Public

3058581 - Macro Error: WorkbookProfile_OnLoad or WorkbookProfile_GetVisible when opening Excel workbooks with embedded profiles

Symptom

When opening Excel workbook with Embedded profile in Analysis Office, one of the errors below occur:

  • Cannot run the macro "WorkbookProfile_OnLoad". The macro may not be available in this workbook or all macros may be disabled.
  • Cannot run the macro "WorkbookProfile_GetVisible". The macro may not be available in this workbook or all macros may be disabled.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Cause

Issue was introduced by a security update from Microsoft in April.

Resolution

Microsoft provided a fix for Office 365 in the Current Channel version 2103 (build 13901.20462) where the issue should not occur anymore.
For further details, please have a look at the Microsoft Release notes:
>> https://docs.microsoft.com/en-us/officeupdates/current-channel

For all other customers who are not on Current channel, Microsoft provided the fix with the May Security update. For further details, please have a look at the following sites for the Microsoft Office updates:

Keywords

Application Builder, Analysis Office, Excel Custom UI, Embedded Profile , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions