View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hunter Hunter is offline
external usenet poster
 
Posts: 28
Default Excel 2007 conversion - this file contains labels in formulas

Opening an Excel 2002 file in Excel 2007 for the first time, I'm greeted with:

"Excel has detected that this file contains lables in formulas. These are
no longer supported in Excel 2007 and will be replaced with cell references.
Your formulas will continue to work correctly. You cannot undo this change.
Do you want to continue?"

Okay, fine. But after I open up the file, how can I tell which cells have
been changed by Excel? Is there a way I can find these formulas in an older
Excel version? I'd like to replace these with cell names not cell
references...

I'd rather not go for the eyeball approach - the file is 6MB with 24 tabs ...