Well, from my side if I wanted a spreadsheet, which updates itself based on some data then think about it from the other way round. Create your spreadsheet as you would like to see it, formatting, layouts, graphs etc.. Setup a VBA macro which runs on startup and loads an Excel file located in a specific place. That other Excel file will contain the data used to create pivots/graphs etc. Then all you would need to do is run the export from SAS as and when you like, overwriting the data Excel grid, and each time you open the main Excel file it would open the data as it is and update.
... View more
