I use Excel 2007 to provide detailed reporting and analysis in pivot tables. All my data is stored in Access tables. Generally, I
1) run Access queries and export to Excel files;
2) manually open Excel template (.xltx) files;
3) manually change the data source of each pivot table one at a time to the new records in the exported (from Access) Excel file.
I know there has to be a better way! Any suggestions are appreciated.
Could someone please point me in the right direction? How should I be thinking differently about this approach?