Hi, I've got multiple pivot tables reports in an excel workbook that all
share the same data source, which is a microsoft access query. I now want to
add a couple of extra fields to the report ... so, i can add this to the
microsoft access query, but it doesn't show up in the pivot table report
automatically when I refresh it. So I open up the pivot table wizard on the
first report and edit the data source to include the extra data fields.
However it's only updated on the report i edited and not any of the other
ones that share this data source. If i go into each of the other reports and
repeat the process, the workbook quadruples in size. Surely there must be an
easier way to update all the reports without having to redo the entire
workbook from scratch.