SAP Knowledge Base Article - Public

2388136 - Error: "The cell or chart that you are trying to change is protected and therefore read-only"


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

Reproducing the Issue

  1. Launch the EPM Add-in SP25 or higher versions.
  2. Open a protected report with VBA embedded.
  3. Click 'Refresh'.


After upgrading to EPM Add-in SP25 Patch1, there is a behavior change of refreshing a protected report with VBA. For details, please refer to note 2296534.


Please add the following line in the configuration file FPMXLClient.dll.config, located in your installation folder:

<add key="AlwaysUnlockAllSheets" value="true"/>

Please be notified this line must be added between <appSettings> and </appSettings>.


AlwaysUnlockAllSheets, appSettings, key, FPMXLClient.dll.config, configuration , KBA , EPM-XLS , EPM Excel Client , BI-RA-AO-XLA , Excel Addin , Problem


SAP BusinessObjects Analysis 2.3, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office