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:
- Office 365 (Semi-Annual Channel)
https://docs.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel - Office 2016/2013 MSI:
https://docs.microsoft.com/en-us/officeupdates/office-updates-msi
Keywords
Application Builder, Analysis Office, Excel Custom UI, Embedded Profile , KBA , BI-RA-AO-XLA , Excel Addin , Problem