this is a fairly common problem.
If you want a full copy of the pivot table to remain static, you can copy
the pivot table and paste it in a new sheet, first as regular paste (to get
format)and then as values to hard copy data.
Let this be your historical file for that date. and just let the pivot table
reflect current data only
this will also reduce the size of the file

"MLK" wrote:

Hopefully someone can help with this one.

Each week our department generates pivot reports and the naming convention
includes the date the report is generated. For example, REPORT A will have
52 reports by the end of the year - one for each week in the year.

In the reports (above the pivot component), data from another source is
pulled in ... stuff that can't be included in the pivot source... such as
headering info, dates, comments etc. I will this source "Extra A". An
example of pulling in info is like this: ='M:\'Extra A'!$C$6

The data in "Extra A" changes each week and is only specific to that week's
reporting.

The issue that was just recently discovered is totally throwing me for a
loop and I don't know how to get around it.

Each time anyone opens a report the links pop-up window appears (to update
the links or not).

If I open up a report from 2 weeks ago, I don't want to update the links
(because the report needs to remain static and NOT be refreshed with this
weeks info), plus I also opened up a report from 4 weeks ago and DIDN'T
update the links (I wanted to compare the reports)... and lo and behold the
report from 2 weeks changed to be the same as the report from 4 weeks ago.

I didn't have the source open, but somehow the report I opened up last,
changed the data in the earlier report??? I tried this out numerous times
with the same results.

How can this happen? And how can I get around it?

The older reports are for historical purposes - but they change if mulitple
reports are open.