Excel linked files

Excel linked files

Didn't find your answer?

I have an Excel budget file which was originally linked to other files, but is no longer (the other files have been copied into sheets in the budget file). Every time I open the file, I am asked do I want to update from the other files, even though the other files no longer exist. How do I get rid of these non-existent links?
BRIAN RODEN

Replies (6)

Please login or register to join the discussion.

avatar
By brianroden
27th Jul 2001 12:57

Excel links
Many thanks for all suggestions. All links successfully eliminated.

Thanks (0)
avatar
By AnonymousUser
04th Jul 2001 14:14

and also
I don't know if the addins suggested look at all links. I have found that 'hidden' links (within references to pivot tables, charts and even Names defined within the old files) can hold the link long after you think it should have disappeared. So if you find your link has not disappeared you may need to look at these areas.

Thanks (0)
aw_logo_2019
By Accounting WEB
02nd Jul 2001 21:34

Excel linked files
Try 1) linking the spreadsheet to itself - this occasionally or 2) just global edit the formulae previously linking to the outside spreadsheet to the tab within the composite spreadsheet (Ctrl - H). This assumes the 'shape' of the new tab has not changed.

Thanks (0)
aw_logo_2019
By Accounting WEB
30th Jun 2001 20:07

There is yet another AddIn file!

You can download yet another addin file which allows you to delete the links selectively rather than all links blindly. The AddIn can be downloaded from here:

http://www.bmsltd.co.uk/MVP/Default.htm

The file is called "FindLink.Zip". You will need Winzip to unzip the file.

The Addin was written by MVP (Microsoft Valuable Professional) member and so it must be good!

Jay Tanna

Thanks (0)
avatar
By AnonymousUser
30th Jun 2001 10:46

ASAP Utilities
The free download ASAP-utilities (for Windows) might also help.

http://www.asap-utilities.com/

Thanks (0)