Also look at Excel 2007 structured referencing to named tables.
regards
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com
"Niek Otten" wrote in message
...
<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