A few weeks ago I outlined how you create smarter Excel spreadsheets if they just so happened to be populated with data. Now I have finally created a sample code page that shows how that can be done here.
The result will be a spreadsheet where the data filters shown in the picture below are open when your reader opens the file for the first time.
If you are into LinkedIn, I am publishing more in that environment. Check the same article here