How do I find those cells in a document that have links to another document
How do I find those cells in a document that have links to another document
Good morning
Go to Edit > Links...
Hope that helps.
As I was saying, go to
Edit > Links...
This will tell you what files the spreadsheet is linked to but not where the links are. A simple Edit > Find... will help you find exactly where the cells are (you don't need to search for the whole path and filename - just a portion of about 5 or 6 characters should do just fine).
The Find facility only looks in the current sheet, so before you start, click the first sheet tab, hold down shift and click the the last sheet. This will select all the tabs, and Excel will search through these.
Hope this is what you need.
Hi leonidas
Try this Add-in to find the links
<findlink.zip>
On this site http://www.bmsltd.ie/MVP/
--
Regards Ron de Bruin
http://www.rondebruin.nl
"leonidas" <[email protected]> wrote in message news:[email protected]...
> How do I find those cells in a document that have links to another document
"Ron de Bruin" wrote:
>
>
> Hi leonidas
>
> Try this Add-in to find the links
> <findlink.zip>
>
>
> On this site http://www.bmsltd.ie/MVP/
>
>
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "leonidas" <[email protected]> wrote in message news:[email protected]...
> > How do I find those cells in a document that have links to another document
>
> Thanks Ron, the adin worked like a charm
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks