Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Links
Hi,
I get this error when I open up the spreadsheet "unable to find external links" So when I go to edit-- links it shows the link. It does not indicate which cell in the worksheet is linked to the "broken" link. Does anyone know how to find the cell in the worksheet that has the broken link? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Links
When I can't find links, I'll use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Jeff wrote: Hi, I get this error when I open up the spreadsheet "unable to find external links" So when I go to edit-- links it shows the link. It does not indicate which cell in the worksheet is linked to the "broken" link. Does anyone know how to find the cell in the worksheet that has the broken link? Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Links
As far as I am aware in the error message box there are 2 buttons: Yes
and No Yes means try to update the external links which means Excel comes up with a file open dialogue and you can see the file name it is looking for. You can then ctrl-f that file name in the entire worksheet. Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) | |||
External links | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Using variable in external links | Excel Discussion (Misc queries) |