Excel 2007 compatibility checker message

  • Thread starter Thread starter jerryk
  • Start date Start date
J

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
 
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
 
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
 
Back
Top