EXCEL: Deleted workbook link

[jooleigh]

A user wanted to disassociate an Excel workbook from another workbook so she deleted the source workbook after saving her new workbook. However, when opening the workbook she gets this error message:

"The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?

To update all linked information, click Yes
To keep the existing information, click No"

I tried to go to Edit, Links to disassociate that particular file but it asks to link to another file. How do we disassociate it from any link? I've tried to copy each sheet in the workbook separately but it still wants to associate it with another workbook. Thanks for any enlightenment you can give me on this.



[sig][/sig]

 

[kathryn]

Your user may has formulas referring to the deleted workbook. Use the Find function to search formulas. If you find formulas referring to the deleted workbook, you may want to copy and PasteSpecial and paste the value of the cell.

Hope that helps [sig]<p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]

 

[BobCrawf]

One among many ways to find these links is under Insert>Name>Define.

Scroll through all the defined names and delete those refering to the 'Other' file.

You will see the 'Other' path and filename in the definition. If the 'Other' file is open you won't see the path.

[sig][/sig]