Remove "automatic links to another workbook"

C

Compu Geek

I have an MS Excel file that was created by copying, pasting and then renaming a previous file. Now, every time I open the new file I get the message:

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

How do I
1. Delete this message?
2. Delete/update the automatic links to the old workbook?
 
R

Ron de Bruin

Hi Compu Geek

Try this Add-in to find the links
<findlink.zip>

On this site http://www.bmsltd.ie/MVP/


Or Edit Links in the Menu Bar if your version have that option

--
Regards Ron de Bruin
http://www.rondebruin.nl


Compu Geek said:
I have an MS Excel file that was created by copying, pasting and then renaming a previous file. Now, every time I open the new file I get the message:

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