SAP Knowledge Base Article - Public

1585448 - Formatting changes in the embedded Excel file are not retained within Xcelsius


  • Unable to add/modify any formatting in the embedded Excel sheet in Xcelsius


  • Microsoft Office 2003 / 2007
  • Xcelsius 2008

Reproducing the Issue

  1. Launch Xcelsius
  2. Open a dashboard
  3. Make some layout, formatting changes in the embedded excel file (ex: Highlight a cell)
  4. Save the Excel file
  5. Save the dashboard
  6. re-open the dashboard

==> The modifications have not been maintained


Currently, Xcelsius uses Excel 2003 SDK to manipulate embedded Excel file. When embedding Excel 2007 file (.xlsx) into Xcelsius, Excel is downgraded to Excel 2003 and user may observe some problems ( ).  


The fix will be expected to considered in BI 4.0 SP8 in ADAPT01696736 as below workaround is not working in BI 4.0 SP6


  1. Open the Excel file
  2. File > Save As > Excel Workbook
  3. The file will be saved as .xlsx
  4. Launch Xcelsius
  5. Import this file in Xcelsius


format layout SDK 2003 2007 compatibility issue lost dissapear not available embed xlsx .xlsx maintain modification , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem


SAP BusinessObjects Xcelsius Enterprise 2008