Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
Excel 2007 - Where is the Accept Labels in Formulas Option? | Excel Discussion (Misc queries) | |||
Excel 2007 conversion - this file contains labels in formulas | Excel Discussion (Misc queries) | |||
labels in formulas | Excel Discussion (Misc queries) |