Unwanted Autocorrect is causing an error

[Steve48]

I am having an autocorrect problem. Excel is Microsoft® Excel® for Microsoft 365 MSO (Version 2306 Build 16.0.16529.20002) 64-bit

I am trying to declare a variable as a PivotTable. Excel keeps changing it to pivotTable with a lower case P which causes an error

I added the these items in the autocorrect options as shown below, but when I reopen this, they have disappeared.

 

[Joe4]

Are you trying to do this in VBA?

If you try to type "PivotTable" in VBA, and it keeps changing it to "pivotTable", that seems to imply that you may already have an object (Procedure, Function, Variable, etc) in VBA already defined that is named "pivotTable". I would recommend searching your whole project in the VBA Edtior for the value "pivotTable" and see if you can find it.

Just go to the VB Editor, hit CTRL+F, and fill out like below, and click "Find Next".

 

[Rick Rothstein]

Are you trying to do this in VBA?

If you try to type "PivotTable" in VBA, and it keeps changing it to "pivotTable", that seems to imply that you may already have an object (Procedure, Function, Variable, etc) in VBA already defined that is named "pivotTable". I would recommend searching your whole project in the VBA Edtior for the value "pivotTable" and see if you can find it.

Just go to the VB Editor, hit CTRL+F, and fill out like below, and click "Find Next".
View attachment 94216

I would also suggest clicking into the "Match Case" checkbox so it will only find that particular text spelled that way.

 

[Steve48]

I have done this. I have multiple local variables defined this way. They are all changed autocorrected from PivotTable to pivotTable

 

[Joe4]

I have done this. I have multiple local variables defined this way. They are all changed autocorrected from PivotTable to pivotTable

Did you try what I suggested up in the first reply in this thread?
You may have some interference going on. You want to at least rule that out.