Change the "Labels in Formulas" function to an add-in.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can the "Labels in Formulas" function in Excel be changed to an add-in ?

This way advanced users like myself (who do not use this 'feature') can
uninstall it.

I find that the tickbox "Accept Labels in Formulas" in the Excel '03 options
dialog box does not work properly. I have this tickbox un-ticked.

However, whenever I try to add a "FALSE" condition to a formula, Excel
ignores the tick box and "assumes" that I'm trying to refer to a
label....then crashes.

This is SOOOOOOOOOOOOOOOOOOOOOOOOOOOO Frustrating !!

If only I could remove this darned "Labels in Formulas" feature from Excel
all together, my quality of life would markedly improve :)


----------------
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/com...4dcee5f&dg=microsoft.public.excel.programming
 
Can the "Labels in Formulas" function in Excel be changed to an add-in ?

This way advanced users like myself (who do not use this 'feature') can
uninstall it.

I find that the tickbox "Accept Labels in Formulas" in the Excel '03 options
dialog box does not work properly. I have this tickbox un-ticked.

However, whenever I try to add a "FALSE" condition to a formula, Excel
ignores the tick box and "assumes" that I'm trying to refer to a
label....then crashes.

Sounds like you need to run a detect and repair. I doubt you can
remove the feature without doing some serious decompiling and hacking
lots of code. Which would be realy illegal and really hard and really
time consuming. What version of excel are you using? do you have any
add-ins? is it a legitimate copy of excel? are you using a legitimate
copy of windows?

AR
 
Well you will be happy to know that Labels in Formulas are no longer
supported in excel 2007 and will be converted to ranges on open
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top