I have a large database of data. Each month I run a query. From this query I produce around 30 pivot tables from this raw data. I also produce 3-4 cumulative charts. All these get put in to one excel file and sent to clients.
I would like to be able to automatically run the query and have the charts and pivot tables automatically update. That way I dont need to create the pivot tables and charts each time. If you think you can help, let me know how you think the best way to go about it is.