LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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 ...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 labels in functions no longer supported! forAbetterWorld Excel Worksheet Functions 14 March 6th 07 04:16 PM
Problems with my links to an excel 2007 file from a word 2007 file sc Links and Linking in Excel 0 February 21st 07 10:12 AM
Excel 2007 - Problems using print preview and PDF/XPS conversion without having a printer defined [email protected] Excel Discussion (Misc queries) 3 February 1st 07 01:20 PM
Excel file conversion? Bobby P. Excel Discussion (Misc queries) 0 July 31st 06 03:14 PM
Excel File Conversion Turquoise_dax Excel Discussion (Misc queries) 0 June 21st 06 02:59 PM


All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"