Check for links in Name definitions, and bear in mind you might need to
check each sheet in the workbook individually, in case the names are
sheet-level rather than book-level. Links within names update only if the
source link source is open; and Excel is very ungraceful about its error
messages in relation to this.
The problem can arise if you have a formula that refers to a name on another
sheet in the same workbook; then you do a SaveAs or move sheets between
books. Under some circumstances the formula will maintain a reference to the
*original* workbook, not the duplicated sheet in the new one.
"joeeng" <joeeng[ at ]discussions.microsoft.com> wrote in message
news:00D835DA-EB73-4B4D-A627-8933555D38BE[ at ]microsoft.com...
[Quoted Text] >I am using Excel 2002. I have 9 workbooks which have extensive linking.
> Eight of the workbooks auto update the links when they are opened by
> themselves. One workbook, however, gives me the warning that some links
> cannot be updated when it is opened by itself. Also, I do not get the
> warning when the other two linked workbooks are opened at the same time I
> open this workbook. Now, the links do seem to be updating, there are no
> #REF
> errors in the workbook, and the link status window shows all links as OK
> (upon opening by itself or when manually updated). Does anyone have any
> ideas why this is happening and how to correct it?
|