Using SharePoint to populate Excel drop downs
Using SharePoint with Excel
Because drop down lists often require updates and must be distributed to multiple users, using a SharePoint list to populate the drop down list minimizes list maintenance requirements. You can use a SharePoint list to populate an Excel drop down, and SharePoint lists can be centrally managed and populated automatically with data from SAP using a scheduled Winshuttle Query.
Many Winshuttle Excel solutions can benefit from using drop-downs to control what a user can enter.
Benefits
- Reduces complexity caused by frequent SAP data updates
- Excel drop down lists are easier to manage