View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Excel 2007 labels in functions no longer supported!

<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