SAP Knowledge Base Article - Public

1203663 - Excel import option definitions

Symptom

Excel import option definitions.

Resolution

 
Clear Data Sources - This action will import the selected spreadsheet and all previously established links will be lost. Use this option when the Excel file is significantly different and you need to delete all the links and start the model again.
 
Refresh Data Sources - This action will import the selected spreadsheet. Use this option when the Excel file is the same or with small changes and you need to keep all previous links. All previously established links to the spreadsheet will be saved. However, if since the last import you have inserted, deleted or modified rows, column or data, it is possible that the links will be affected. Review them before saving the model.
 
Refresh Spreadsheet Format - When selecting Refresh Data Sources you have the additional option to refresh the spreadsheet format. Use this option when some spreadsheet formatting parameters have changed which you want updated. These can include:
 
  • numeric format (percent, currency, data and time formats)
  • cell width
  • cell height
  • cell color
  • cell border etc (for table and label components)
 
Sometimes it is convenient to not refresh the spreadsheet format, such as when you have already spent some time customizing formatting parameters for a component and do not want that information to be lost on re-import.

Keywords

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

Product

SAP BusinessObjects Dashboards 3.0 ; SAP BusinessObjects Dashboards 3.5 ; SAP BusinessObjects Dashboards 4.5 ; SAP BusinessObjects Dashboards software 4.0