Suppose you have "Name" in cell A1 and "Bob" in A2. But you didn't define A2
to be called "Name". If you use "labels in formulas", then simply referring
to =NAME in a formula somewhere would have excel understand what you meant,
and will use cell A2, just as IF you named cell A2 "Name." In excel 2007, it
will simply change =NAME to =A2. Shouldn't be a problem.
Bob Umlas
Excel MVP
"forAbetterWorld" wrote in
message ...
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