This workbook is linked to an other file...

[Jan Thorstensen]

I keep getting up an annoying message every time
I open a specific workbook. It displays a alert that
says that this workbook is linked to an other file, do
you want to update...?.. or something like that.

How can I avoid seeing this message?
Any help or tips will be appreciated, thanks.


Jan

PS. I don't want to program with
Application.DisplayAlerts = False because then I won't see
the save dialog when I close the file.

 

[Freemini]

If you go to Edit, Links you will see a file name which is linked to
your file. Make a note of the file i.e. c:\otherfile.xls and then close
the window.

Use find to find the linked cells using the file name you found above.
If the cell has data in it which you want to keep copy and paste
special, values. If the cell should be getting it's data from another
cell on your sheet amend the formula. If not delete the reference to
the other file.

Repeat the above for all occurances of the reference.

Repeat for references to other files.

Save the workbook in the normal way, close and then re-open. You should
not get the 'Linked file' message.

Hope this helps
Mike

 

[Dave Peterson]

I like Bill Manville's addin:

Findlink.zip from
http://www.BMSLtd.co.uk/mvp

 

[Jan]

Thank you very much, both Dave Peterson and Mike.
That solved my problem.
Jan