J
John Ortt
Hi everyone,
I am hoping somebody can give me an easy way of changing the Access Database
which pivot tables use for their source data.
I have an excel spreadasheet which includes approx 20 pivot tables which are
linked to stock check data.
Since we have now run a fresh stock check I would like to link the file to
the latest set of data without deleting every table and recreating them.
If anyione has any good ideas on how I could do this I would be very
grateful.
Thankyou,
John Ortt
I am hoping somebody can give me an easy way of changing the Access Database
which pivot tables use for their source data.
I have an excel spreadasheet which includes approx 20 pivot tables which are
linked to stock check data.
Since we have now run a fresh stock check I would like to link the file to
the latest set of data without deleting every table and recreating them.
If anyione has any good ideas on how I could do this I would be very
grateful.
Thankyou,
John Ortt