[Solved] Automatic Links

mhofer · Sep 8th 2003

I did a couple copy & paste link from one sheet to another. It caused the dreaded automatic links message when the sheet is opened. I searched & deleted the link in each formula I could find that had them but still can't get rid of the message when the sheet opens. Changing the links to Manual is not an available option. Any ideas on how to get rid of the automatic links message?

rem1224 · Sep 8th 2003

Hi,

Sounds like you still have a link hanging around somewhere.

Check the Edit / Links menu item and see if there are still links defined there.

.....Ralph

pennysaver · Sep 8th 2003

Have you tried Tools-->Options-->Edit-->Ask to Update Automatic Links?

Imbuzi · Sep 8th 2003

Hi Mhofer,

Have a look to see if you have any named ranges that have a #Ref in them, these sometimes happen when you start linking workbooks with named ranges. to find the named ranges (Ctrl+F3).

HTH

Graeme

mhofer · Sep 9th 2003

Tried all suggestions.
Turned off the Question - didn't stop it from showing that it can't find the file to link to.
I did find a REF in name ranges and fixed it.
Edit links does show a link but I still can't find it. Did a find for protions of the workbook name it is looking for and came up empty. Is there another way to find the linked cell?
MHofer

pennysaver · Sep 9th 2003

Here's a Microsoft KB article with a link to an exe file that will find and delete hidden or missing links

http://support.microsoft.com/?kbid=188449

HTH,

Smitty

mhofer · Sep 24th 2003

Finally got back to this.
Thanks for all the suggestions.
While the DeleteLinks add-in didn't work for this workbook it will be a valuable tool to have in the future I'm sure. I did some more searches within the workbook and finally found one last REF in a formula. Cleared it and the problem went away. Thanks much!:biggrin:

[Solved] Automatic Links

Participate now!

Share