Excel Automatically Changes Case in Formula Against My Wishes

**tarpmaster** · 11-05-2012, 09:33 PM

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 that are 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

**vlady** · 11-05-2012, 10:20 PM

did you tried turning off the auto-correct features...

**tarpmaster** · 11-05-2012, 10:22 PM

Yes. Thanks for the suggestion, though.

**abousetta** · 11-05-2012, 10:23 PM

Hello and welcome to the forum,

You could try turning autocorrect off (Options >> Proofing >> Autocorrect options).

More importantly can you show us the formula you are talking about because I don't seem to have this problem.

abousetta

**tarpmaster** · 11-05-2012, 10:27 PM

Turning autocorrect off did not fix the problem. What I want is "=wwsHideRows(19)". Excel changes it to "=wwshiderows(19)". This is an example of many similar formulas I need to use. I know there is a way to fix it because the developer alerted me to this problem. He just didn't explain very well how to fix it. Note that these forumulas are add-in formulas.