Excel 2007 compatibility checker message

[jerryk]

I have a spreadsheet created in Excel 2003. I open it in Excel 2007 and Save
As without making any changes. I get a compatibility error: "Some formulas
in this workbook are linked to other workbooks that are closed." It does not
have a "find" link. How do I find these formulas?
Thanks.
JerryK

 

[Jim Rech]

You could use Edit Links on the Data tab to see what the names of the linked
workbooks are and then do a Find on them. If that doesn't work you might
try Bill Manville's Find Link utility although I don't know how it works
with Excel 2007:

http://www.oaltd.co.uk/MVP/Default.htm

 

[jerryk]

Thank you. I used the Find Link utility in 2003 to fix my master
spreadsheet. Now 2007 does not complain about it any more.
JerryK