SAP Knowledge Base Article - Public

2762547 - Dropdown Field cannot be used via Excel Add-In anymore after Saving

Symptom

You created a dropdown field via Data Validation in the Excel Add-In and saved the workbook to the system. After reopening the workbook the drop-down field does not react anymore and cannot be used.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Open Excel and log in via the Excel Add-In.
  2. Insert a report and adjust as required.
  3. Additionally, create an Excel drop down field and maintain all options as required.
  4. Save this as a design workbook or public workbook.

When you close and open this file again, the drop-down field does not work. No options are available to choose from, or the field does not react at all. 

Cause

The options for the drop-down list were created on a different worksheet.

Resolution

Please ensure that the selection options for the list are on the same sheet.

Keywords

Excel Add-in; workbook; dropdown; drop down field, report , KBA , AP-RC-ANA-UI-XLS , C4C, ByD, Travel: Excel AddIn , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Cloud for Customer add-ins all versions