Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i find which sheets contain links?
i have a workbook with a lot of sheets.
every time i open it, the system ask me ti update the links, but, i dont remember that i have links to other workbooks at all ! i can't find where are the links the system refer to. thanks for your help. dov rozenfeld |
#2
|
|||
|
|||
Try Bill Manville's excellent "FindLink" utility ..
It's available at Stephen Bullen's page: http://www.oaltd.co.uk/MVP/Default.htm -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "dov" wrote in message ... i have a workbook with a lot of sheets. every time i open it, the system ask me ti update the links, but, i dont remember that i have links to other workbooks at all ! i can't find where are the links the system refer to. thanks for your help. dov rozenfeld |
#3
|
|||
|
|||
dov wrote: i have a workbook with a lot of sheets. every time i open it, the system ask me ti update the links, but, i dont remember that i have links to other workbooks at all ! i can't find where are the links the system refer to. thanks for your help. dov rozenfeld Dov, I find them by doing a find (ctrl+F) and searching for an exclamation point. "!" All links to other sheets and workbooks have them. Should shorten the hunt, in any event. Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
Add "FIND LINKS" to EXCEL Audit function | Excel Worksheet Functions | |||
Find (Ctrl +F) not searching all open sheets | Excel Worksheet Functions | |||
find links to another workbook | Excel Discussion (Misc queries) | |||
How to find cells with links to other workbooks? | Excel Discussion (Misc queries) |