| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linked object
I have an Excel workbook with a link to another Excel file, but I don't know what's linked to that file: a formula, a graph, or what. How can I find what is linked to that file? Thank you very much in advance!! Kind regards, -- JavierFM ------------------------------------------------------------------------ JavierFM's Profile: http://www.excelforum.com/member.php...o&userid=28062 View this thread: http://www.excelforum.com/showthread...hreadid=475773 |
|
#2
|
|||
|
|||
|
Javier,
Go through each spreadsheet in turn and enter Find mode by pressing ctrl+F. In the 'Find what' box, enter ' :\ '. This will find any link to another file. If :\ is found, the cell will be selected and you can then decide if you want to keep the link or not. Ewan. "JavierFM" wrote: I have an Excel workbook with a link to another Excel file, but I don't know what's linked to that file: a formula, a graph, or what. How can I find what is linked to that file? Thank you very much in advance!! Kind regards, -- JavierFM ------------------------------------------------------------------------ JavierFM's Profile: http://www.excelforum.com/member.php...o&userid=28062 View this thread: http://www.excelforum.com/showthread...hreadid=475773 |
|
#3
|
|||
|
|||
|
open it and have a look.
"JavierFM" wrote in message ... I have an Excel workbook with a link to another Excel file, but I don't know what's linked to that file: a formula, a graph, or what. How can I find what is linked to that file? Thank you very much in advance!! Kind regards, -- JavierFM ------------------------------------------------------------------------ JavierFM's Profile: http://www.excelforum.com/member.php...o&userid=28062 View this thread: http://www.excelforum.com/showthread...hreadid=475773 |
|
#4
|
|||
|
|||
|
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm JavierFM wrote: I have an Excel workbook with a link to another Excel file, but I don't know what's linked to that file: a formula, a graph, or what. How can I find what is linked to that file? Thank you very much in advance!! Kind regards, -- JavierFM ------------------------------------------------------------------------ JavierFM's Profile: http://www.excelforum.com/member.php...o&userid=28062 View this thread: http://www.excelforum.com/showthread...hreadid=475773 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| disabling linked object before you open a file | Excel Discussion (Misc queries) | |||
| Creating a Powerpoint object (in XP onwards) with an ActiveWindow | Excel Discussion (Misc queries) | |||
| How do I automatically open linked documents in Excel? | New Users to Excel | |||
| VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
| Linked worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
