SAP Knowledge Base Article - Public

1542421 - Unable to modify Excel cell value in Xcelsius 2008.

Symptom

Values can not be edited in embeded Excel cells in Xcelsius 2008.

Environment

  • Xcelsius 2008 Service Pack 2.
  • Microsoft Excel 2003.

Reproducing the Issue

  1. Open an existing xlf file in Xcelsius 2008.
  2. Change a cell value in Excel which is aligned to a label component. 
  3. Click Preview. No changes are reflected in the label. 
  4. In preview mode go to File then click Snapshot and select Current Excel Data. No changes are reflected here as well. 

Cause

Excel file is password protected.

Resolution

Remove the password protection of the Excel file and then it is possible to modify the Excel cell content.

See Also

Excel, Modify, Protect. Edit.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008