I have created a report in that feeds an Excel workbook contains several
worksheets. The first worksheet, "master", contains all the data that I need to
create Pivot Tables that are stored on other worksheets within the workbook.
In order to populate "master", I am using the filter, "prior month".
The first time I prepared the report, everything was fine. However, the second
month I'm trying to do this, the "master" report is updated with current
(February) data, but the pivot tables still contain data from January.
I've looked at the options in Excel and enabled the "refresh on open" function.
This may really be an Excel question and not an ExportWiz question, but I'm
finally making some progress with your application, which has been extremely
helpful.
Thanks for any assistance.
If you have not specified the Pivot table under the
Pivot table options (available via the "PT" for pivot table button [near the
chart button] or also in Excel options "Pivot tables linked to this") it may be
as simple as linking each pivot table you want updated with the new data.
You need to tell ExportWiz which pivot tables link to
the data as you may also have pivot tables you don't want linked to the exported
data (i.e. linking to static data in another sheet).
