Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External links
Hi,
I inherited some files from my predecessor, in which there are so many external links to so many other files. I need to know which cells are linked. I tried checking on 'Edit -- Links' it only shows the source but not the destination cells. Any help to find the destination cells pls? - Thanks -- Cheers ! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
External links
Download and use Bill Manville's FindLink add-in.
http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Fri, 22 Aug 2008 07:52:00 -0700, Sena wrote: Hi, I inherited some files from my predecessor, in which there are so many external links to so many other files. I need to know which cells are linked. I tried checking on 'Edit -- Links' it only shows the source but not the destination cells. Any help to find the destination cells pls? - Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
External links
This is a ridiculous solution. Simply open the Find search box and search for
square brackets [ or ]. Every link has one in it, this is the easiest and quickest way to find a link in an Excel file. "Gord Dibben" wrote: Download and use Bill Manville's FindLink add-in. http://www.oaltd.co.uk/MVP/Default.htm |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
External links
Then you haven't used links very often.
Links can be difficult to find and they can hide in places where Edit|Find can't look. whydoyoumakethingsoverlycomplicated wrote: This is a ridiculous solution. Simply open the Find search box and search for square brackets [ or ]. Every link has one in it, this is the easiest and quickest way to find a link in an Excel file. "Gord Dibben" wrote: Download and use Bill Manville's FindLink add-in. http://www.oaltd.co.uk/MVP/Default.htm -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
External links
And if the links are in defined names?
What then? Gord On Wed, 27 Jan 2010 04:07:02 -0800, whydoyoumakethingsoverlycomplicated icrosoft.com wrote: This is a ridiculous solution. Simply open the Find search box and search for square brackets [ or ]. Every link has one in it, this is the easiest and quickest way to find a link in an Excel file. "Gord Dibben" wrote: Download and use Bill Manville's FindLink add-in. http://www.oaltd.co.uk/MVP/Default.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External links | Excel Discussion (Misc queries) | |||
External Links | Links and Linking in Excel | |||
#Value w external links | Excel Discussion (Misc queries) | |||
External links | Excel Discussion (Misc queries) | |||
external links | Excel Worksheet Functions |