I used the video here to try to run a query, paste those results into an excel template. The excel template has 2 tabs (worksheets) only, the first one is the summary tab with 4 pivot tables and two graphs and the second tab (worksheet) with all the data from the query.
From the video, I have been able to get the results of the query to paste onto the second tab and then have the data reload/refresh when the user opens the file.
One glitch I am running into though is with the formatting. My template was set to update upon opening the file and each pivot table was set to NOT autofit column widths on update as I had set them at a specific width. This setting is being overwritten the data is copied over with the new data.
Is there a way to keep these settings in tact? If not, my graphs get all screwy and all the columns change size as well.
Thank you indavance.
I am using Toad Data Point 3.7.