SAP Knowledge Base Article - Public

2585720 - Refresh Button greyed out in Excel Add-in

Symptom

Refresh button is greyed out in the downloaded report in Excel format from Business Analytics Work Center.

Environment

  • SAP Business ByDesign
  • SAP Cloud for Customer 

Reproducing the Issue

  1. Log in into C4C or Business ByDesign system with your credentials.
  2. Go to Business Analytics Work Center.
  3. Open any Report.
  4. Download the report to Excel.
  5. Now Open the locally saved Excel Report.
  6. Log in to C4C System or Business ByDesign in the excel Add in.

Cause

Download to Microsoft Excel in XML format is a different functionality that just downloads Content and this information is static.
This is expected system behaviour.

Resolution

Refresh operation is enabled for the reports inserted into the excel Add in only after logging in into the system.

  • Open the Excel Add in.
  • Log in into C4C or Business ByDesign system with your credentials.
  • Use the Insert report option to extract the Report data from the C4C system.
  • You can choose the view and selection required.
  • Refresh button will be enabled.Click on Refresh Button.

See Also

2994110 - Refresh Button Disabled in Excel Report

Keywords

Excel Addin, Refresh Button , KBA , reports , refresh button in excel add-in , reports refresh in excel , refresh button , AP-RC-ANA-UI-XLS , C4C, ByD, Travel: Excel AddIn , How To

Product

SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Cloud for Customer add-ins 1802 ; SAP Hybris Cloud for Customer add-ins 1711