:) Thanks for all the loving replies. The construct should never have been
named "Label"; maybe "Presumed Label". I have never used them and i think
the untoward message infers a "Presumed Label" which in fact is not intended;
simply fortuitous arrangement :). Symphony had a manuever to make use of a
fortuitous arrangement to convert a presumed label to a "name". That was
simply convenience. Excel, to my knowledge has never offered that
convenience creating a name. All better now... Beer's on me
"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