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
- Open Excel and log in via the Excel Add-In.
- Insert a report and adjust as required.
- Additionally, create an Excel drop down field and maintain all options as required.
- 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