A 'Label in a Formula' is what we thought you were carrying on about - it was
a (poorly implemented and easily corrupted) way of using the heading you
entered in a column or left side of a row as a pointer to data within the
column/row.
A name is actually a named range that you create/define. Use those instead.
A name can refer to a single cell, a group of contiguous cells or even a
group of 'geographically' separated cells.
From Help on "Labels and Names in formulas" from Excel 2003 (edited)
"You can use the labels of columns and rows on a worksheet to refer to the
cells within those columns and rows. Or you can create descriptive names
(name: A word or string of characters that represents a cell, range of cells,
formula, or constant value. Use easy-to-understand names, such as Products,
to refer to hard to understand ranges, such as Sales!C20:C30.) to represent
cells, ranges of cells, formulas, or constant (constant: A value that is not
calculated and, therefore, does not change. For example, the number 210, and
the text "Quarterly Earnings" are constants. An expression, or a value
resulting from an expression, is not a constant.) values. Labels can be used
in formulas that refer to data on the same worksheet; if you want to
represent a range on another worksheet, use a name.
......
Note By default, Excel does not recognize labels in formulas. To use labels
in formulas, click Options on the Tools menu, and then click the Calculation
tab. Under Workbook options, select the Accept labels in formulas check box."
End of quote. As you see, "By default, Excel does not recognize labels in
formulas..." so an effort had to be made to do so.
"forAbetterWorld" wrote:
thank you for the opportunity to eat some crow. Pressing ahead, may i ask
what is meant by "label in formula". I started this game with Lotus Symphony
in 1982. Presumably "label" and "name" are not synonyms with respect to use
as cell reference in formula. Having pursued Help, i get no response to
search for "Labels in Formulas". So what is the basis of the threatening
message when opening a file: "Excel has detected that this file contains
labels 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 wish to continue?" Name
manager appears to be properly managing names which i took to be synonymous
with labels in the above imposing MS message. What is a "label" (as opposed
to chart label or axis label...) and how can i find, in an opened file,
opting Yes to the message, the basis incurring the message?
"Niek Otten" wrote:
<i must face the challenge of uninstalling Excel 2007 and re-installing the more capable Excel 2003
I wouldn't do that if I were you.
Labels have always been warned for, mainly because they were poorly implemented.
Use Defined Names instead. You probably won't have to change one formula.
In the Formulas tab, Defined Names box, choose Create from selection.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"forAbetterWorld" wrote in message
...
| Unbelievable! What BoneHead would fix a wiring problem by axing the wire?
| Labels have been a tool for proper programming since they technically,
| thankfully could be supported. If some users do not want the benefit, then
| make use of labels an option. More elegantly, Microsoft, fix the code
| adapting to mis-use of labels in formulas by offering more graceful options
| for users to continue the pursuit with Excel. Having built a complete and
| reliable Accounting System depending on properly labeled cell references in
| formulas (for audit and debug), i am asked as i open a 2003 file in the "NEW"
| 2007, TO SCRAP MY INVESTMENT IN PROPER SPREADSHEET PROGRAMMING, OR NOT USE
| THE PRODUCT! UNBELIEVABLE !!!!!!!!!!!!! Now i must face the challenge of
| uninstalling Excel 2007 and re-installing the more capable Excel 2003. This
| tryanny will be addressed. I encourage your support and efforts to establish
| an Act of Congress for Regulation of Software Civility. GOD save Earth!
|
| ----------------
| This post is a suggestion for Microsoft, and Microsoft responds to the
| suggestions with the most votes. To vote for this suggestion, click the "I
| Agree" button in the message pane. If you do not see the button, follow this
| link to open the suggestion in the Microsoft Web-based Newsreader and then
| click "I Agree" in the message pane.
|
|
http://www.microsoft.com/office/comm...et.f unctions