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.




--
Hemlock

Opening several similar charts shows same data
 

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?




--
Hemlock