Try Adventure Works with Azure


In this example you can test how fast Excel could be dealing with 20,000 contact names coming from Azure. The spreadsheet uses a list of names obtained using the statement SELECT FirstName, LastName AS Name FROM Person.Person ORDER BY FirstName directly from then AdventureWorks2012 database.

Then using a ComboBox, which is a standard ActiveX control, you can choose one of those names to, in turn, feed another formula that gets details of that contact.

Leave a comment