Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Suppress Labels in Formulas Msg in 2007

I have a tool that will open 1000+ spreadsheets to pull data from each
in a data mining effort. I know that Excel 2007 no longer supports
labels in formulas and never used them anyway. I preferred named
ranges. However, the spreadsheets I need to open do have labels and
Excel 2007 is so pleased with its message to tell me that they are no
longer supported that it gets displayed for every spreadsheet being
opened.

This sorta defeats a lot of the benefits from automating the data
mining effort as every spreadsheet requires manual intervention.

Does anyone have a way to suppress this message?

Fervently hoping.....

Thank you,
Jeff Jones
Wake Forest, NC
Reply
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 text labels in category axis - missing labels Boris Charts and Charting in Excel 3 December 5th 08 04:33 PM
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm skelly Excel Discussion (Misc queries) 1 October 29th 08 11:22 PM
Excel 2007 - Where is the Accept Labels in Formulas Option? headly Excel Discussion (Misc queries) 3 June 8th 07 12:58 PM
Excel 2007 conversion - this file contains labels in formulas Hunter Excel Discussion (Misc queries) 6 March 20th 07 01:00 PM
labels in formulas Eleazar Excel Discussion (Misc queries) 1 July 11th 06 12:05 PM


All times are GMT +1. The time now is 09:02 PM.

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

About Us

"It's about Microsoft Excel"