File Link (Excel 97 – Serv Pack R2)

Topic

New Reply

Hello! I’m hoping someone can give me a hint on how to omit a link to a file that doesn’t exist anymore. Every time I open this one file it asks me if I’d like to update the links. I no longer have any links (or any that I can find), plus the file it says it’s linked to, doesn’t exist anymore. I’ve gone to the toolbar to “Edit” and the selected “Links” and this is where I see the file name and location that doesn’t exist anymore. Unfortunately the option to delete the link doesn’t exist. I’ve tried to copy each worksheet in the file to a new file and save to see if the old link goes away, and I have no luck. I’ve viewed all the formulas in all the worksheets, and see no formulas that would cause it to look for a link… I must be missing something. I’ll take any suggestions.
Thanks!
LJM

Reply | Quote

Replies

Does This Thread help?

Reply | Quote

Does This Thread help?

Reply | Quote

Try Bill Manville’s FindLink a addin.

Note: names may also contain links to other books.
Steve

Reply | Quote

Thanks to you both for the free “find link” option. It worked… the link is finally deleted!
Thanks again,
LJM

Reply | Quote

Thanks to you both for the free “find link” option. It worked… the link is finally deleted!
Thanks again,
LJM

Reply | Quote

Try Bill Manville’s FindLink a addin.

Note: names may also contain links to other books.
Steve

Reply | Quote