Using SharePoint to populate Excel drop downs

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