Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find links to another workbook
I have a huge workbook that somehow has a link to another workbook. I tried
to search for the [ and found some of the links and removed them, but when I open the workbook it still states that there are links. How else can I fnd them. The workbook contains 30 sheets so looking in the cells will not help. Thanks |
#2
|
|||
|
|||
There are several other options;
1) You may not know bu you can search multiple sheet by holding down CTRL or SHIFT then fist to last sheet, then doing a find on .xls 2) Use the Find Link add-in available at http://www.oaltd.co.uk/MVP/Default.htm Totaly free 3) Get a copy of John Walkenbacs PUP add-in (£30 or $40) this is more sophisticated. Hope that helps Jimbola "Patricia" wrote: I have a huge workbook that somehow has a link to another workbook. I tried to search for the [ and found some of the links and removed them, but when I open the workbook it still states that there are links. How else can I fnd them. The workbook contains 30 sheets so looking in the cells will not help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
How to find cells with links to other workbooks? | Excel Discussion (Misc queries) | |||
"Find" in workbook | Excel Discussion (Misc queries) | |||
Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |