I'm confused about what links are updating.

You open workbook_A (answering no to the update links to the accounting data).

Then you open workbook_B (answering no to the update links to the accounting
data), but the links back to workbook_A get updated?

If that's true, then this is normal behavior. I've never seen excel not update
links between two workbooks that are open in the same instance. (In fact, I'd
bet that the behavior you saw on that other pc could be explained by different
instances of excel--or links pointing to a different (closed) workbook.)



Bryan wrote:

Here is one that has got me completely stumped.

The Problem:
I have two spreadsheets that link to files created by an accounting program.
The links are identical although the data is diffrent depending on when the
link was last updated. I open up one spreadsheet and select Don't update. I
then open the other within the same instance of excel and select Don't
update. The values in the cells with the identical links update with the
first spreadsheet values. The Kicker is that one one computer this does not
occur.

What I have done:
I have looked for several days to find a solution. (Google, several Forums,
etc.) I place a computer with the problem beside on without and compared
settings. I checked to be sure we both had identical versions of Excel. I
have run all available updates. Any other ideas would be greatly appreciated

--

Dave Peterson