If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel changes case in formulas against my wishes

Thread starter tarpmaster
Start date Nov 5, 2012
Tags

case in formulas changing formulas

tarpmaster

New Member

Nov 5, 2012

I am using a 3rd party Excel Add-on that uses javascript to convert Excel spreadsheets to HTML. There are several formulas with this add-on that relies on formulas being case sensitive. For instance, I want the formula to say =wwsHideRows but then Excel automatically changes it to =wwshiderows. In that case, the formula does not work after conversion to HTML. I have tried fixing this problem with autocorrect, autocomplete and a variety of other "tools" options but I cannot get Excel to stop doing this. I think it has to do with remembering the formula the way I typed it once before. How do I clear Excel of that memory? Any other ideas?

Chris