Excel 2003 - Don't Update Issue

[ElDorado]

I'm currently using Excel 2003 in WindowsXP. The problem is the following: I
have 2 Excel files (A and B) which they linked to other files (LinkA and
LinkB) respectively. When I open the first file Excel prompts me to update
the file or not. Then, I click Don't Update and so far so good. However, when
I open the second file which also has a link to another file (linkB) and it
asks me to update or not the file and I select Don't Update, File "A" changes
its formula results even though file A and B are not linked with each other
at all. The interesting part is that File "A" changed the formula results to
a number that doesn't make any sense. So I need to go to Edit > Links >
Update Links to fix the formula results again. The only way I've found to go
around this issue is by opening the files in separate Excel sessions. If
anybody knows where I could find a patch for this issue I would appreciated.

 

[Sheeloo]

Very difficult to find the problem without looking at the files or some
examples of the formula in A which get updated and what they get updated to.
Pl. post 2-3 examples...

What happens if
1. You chose to update?
2. If you open the file in reverse order?

Try renaming file B and then open A followed by B as you have been doing...
Let us know what happens.

 

[ElDorado]

Same problem.
Same issue.

Keep in mind that the files are not linked to each other. If I click
"Update" then the file updates its data correctly. The problem is when I
click Don't Update in both files. A lot of the times I don't want to update
the files, so I have to open another Excel session (by clicking on the Excel
icon) to open the second file, thus avoid this issue. The problem is that
it's very cumbersome having to open the file in different sessions. It seems
like this problem happens on and off. I've tried to pinpoint the cause of it,
but I can't figure it out. It happens with files with macros and file w/o
macros in it.

 

[ElDorado]

In some files, I do have a Workbook_Open Macro to Password Protect the file
automatically when the file is opened. I wonder if that has anything to do
with it. Here is the code:

Private Sub ProtectSheetsPwd()

ThisWorkbook.Activate

For Each Sh In ThisWorkbook.Worksheets
Sh.Protect Password:="xxxxxxx", _
DrawingObjects:=True, Contents:=True, Scenarios:=True,
UserInterfaceOnly:=True, _
AllowFormattingColumns:=True, AllowFormattingRows:=True
Next Sh

For Each Sh In Sheets(Array("Template", "Assumptions", "Index"))
Sh.Visible = xlVeryHidden
Next Sh

End Sub

 

[ElDorado]

Does anybody have an answer for this problem? Thanks!