HELP finding links to external workbooks

[mbrittb]

I have an excel workbook, that tells me there are links to external workbooks when I open it up. To my knowledge there isn't any. I have been looking for hours trying to find these links, and have been unsuccessful. I am using Excel 97, is there anyway I can find out where these links are.

Thanks,

Britt

 

[VoG]

This should help http://j-walk.com/ss/excel/usertips/tip054.htm

 

[mbrittb]

VoG thanks for the link, but I have one problem. The files that the links are listed for do not exist, in fact they havn't exited for quite sometime (long before the workbook in question was created). Any other ideas.

Thanks,

Britt

 

[mbrittb]

I got it fixed. I just skipped step one, and went straight to deleting the bad "Defined Names" on each sheet.

Thanks,

Britt