I have a pivot table in Excel that imports data from Access. The data is for
a fiscal week (and is updated every week). We have a couple of columns
outside of the pivot table that give totals for data in the pivot table
(total hours, yield, etc..) Each week when a new week is added to the table
and we refresh, the pivot table is updated, but the totals outside the pivot
table don't change. Is there any way to link or connect these columns so
that they refresh and update along with the pivot table? Also, is there any
way to keep formatting the same when refreshing? For example, when I change
the column width and refresh, the width goes back to the way it was, even if
I click save first.
Thanks in advance!