how do i find which sheets contain links?

D

dov

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
 
P

Pierre

dov said:
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
Click to expand...

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
 
Top