I wouldn't mind seeing the workbook if you can send it to me. Naturally you
should clear all the meaningful data first, just as long as what's left
still manifests the problem.

--
Jim
"Lars" wrote in message
...
| Hi Jim, Many thanks for your reply. I can't reproduce this problem either
| using a new workbook and I have tried everything possible. But with THIS
| particular workbook, (that was sent to me by one of my clients in a major
| bank in Hong Kong), on opening, it updates the links and destroys the old
| values however way the dialog is validated. It would appear that this
| workbook has become currupted in some way. I did find a way to prevent the
| links from updating by first opening a blank workbook, then, in the
| Calculation tab in the Tools Options dialog, selecting the Manual option
| and clearing the Recalculate before save checkbox. Then I open the other
| workbook and it did not corrupt the old values this time. Then I was able
to
| copy all the worksheets into a new workbook. Unfortunately, when saving
the
| new workbook, all the values were corrupted again. So the bug is still
| there...
|
| I am very grateful for your help. Perhaps, there is someone out there who
| might have met up with this problem (it seems to be a rare case) who could
| suggest another way out of this dilemma ?
|
| Many thanks again :)
|
| "Jim Rech" wrote:
|
| Can anyone suggest a way to correct this bug ?
|
| I can't reproduce this problem. If I click don't update the linked
formulas
| do not change. Also, if I select "Don't display alert and don't update
| automatic links" under Startup Prompt I do not even see the prompt.
|
| --
| Jim
| "Lars" wrote in message
| ...
| | When opening an Excel 2003 workbook that contains links to other data
| | sources, the "Update / Don't Update Links?" dialog appears. It is
| necessary
| | NOT to update the links when the workbook is used on a stand-alone PC.
| | Unfortunately, the links ARE updated after clicking the "Dont Update"
| button,
| | resulting in the #NAME? error replacing the displayed values on the
| | worksheet. Can anyone suggest a way to correct this bug ?
|
|
|