finding an excel link

Posted by Liliana Avancena on February 15, 2001 3:30 PM

I have a workbook with about 10 sheets in it. I know that there are several links to other workbooks and I know the names of those linked spreadsheets. What I need to find out is what data is it that is linked to those other workbooks so that I can take out the links. Is there any easy way of finding where these links are hidden?

Please advise and thanks for any help you all can provide

Posted by Dave Hawley on February 15, 2001 4:56 PM

Liliana, Right click on a worsheet tab and select "Select all sheets", go to Edit>Find and search for *'! in Formulas.

Dave

OzGrid Business Applications

Posted by Liliana Avancena on February 16, 2001 10:05 AM

Dave, thanks tremendously for this bit of information...