Microsoft knew from the day after the release of whatever version it was
(2000 or 2002, I think) that allowing labels to be used in formulas was a
big mistake. The writing was on the wall by XL2003 which had this feature
turned off by default. Many Excel writer have preached about the evils of
labels but some did not listen. There is no "fix" other than removing the
feature. Why not spend some time creating/defining Names?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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