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.