Suppress Labels in Formulas Msg in 2007

J

JP Jones

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - Where is the Accept Labels in Formulas Option? 3
Error when copying from spreadsheets in Office 2007 1
Labels in Formulas requires manual refresh? 2
Excel 2007 conversion - this file contains labels in formulas 6
An error msg in Excel 2007 regarding Linking but no linking in fil 0
Excel Calculations in Sharepoint 2007 0
Excel 2007 labels in formulas no longer supported! 1
Extremely slow response times in Excel 2007 4

Top