When using EPM Add-in older versions, a protected report with Visual Basic for Applications (VBA) can be refreshed successfully.
However, when using EPM Add-in SP25 Patch1 or higer versions, the same report causes error when click refresh.
The error message is as below:
[Error Message on Microsoft Visual Basic]
Run-time error '1004':
The cell or chart that you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Review tab, Change Group). You may be prompted for a password.
- SAP BusinessObjects EPM solutions, add-in for Microsoft Office SP 25 Patch 01 or higher versions
- SAP BusinessObjects Analysis, edition for Microsoft Office 2.3 or higer versions
AlwaysUnlockAllSheets, appSettings, key, FPMXLClient.dll.config, configuration , KBA , EPM-XLS , EPM Excel Client , BI-RA-AO-XLA , Excel Addin , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.