Opening several similar charts shows same data

I have many saved files that are data from an external device. In the old version of excel that I was using, I was asked wether I want the data to update or not when I open these files. If I select "no" they would open with the saved data and display with no trouble.

When I try to open these files with Excel 2007 I get the message that automatic update has been disabled, but the charts in every file I open look the same. No matter how many files I open, all the charts look like the one from the first file opened. I have tried changing the automatic update options, but this doesn't help. To clarify, the charts are set up the same (the same file is copied with different data) but the individual data sets should be different. The listed data the chart is based on is even the same. If I open the files with the old version of Excel they are different.

I have been using a different machine with an older version of Excel to look at this data, but I need something better than this work-around. Thanks in advance for you help.

I tried again to fix this issue, no progress so far. When I open a file with external data links the data is not updated and the link is disabled (which is good when I am looking at saved data). When I open another file (copy of the first with differnt data) nothing is updated, the data from the first file is still displayed.

I think there must be an option that loads the saved data without looking for new data (which isn't there since the input device isn't on), a setting inbetween "disable" and "fully on" if you will.


Anybody have any ideas?