My entries are being changed!

[swyck]

In Excel 2007, if I type the string ACN, it is automatically changed
to CAN.

I dont want that to happen and dont know how to turn that off. I
tried turning off auto-entry but that didnt work. I tried entering
the text in quotes, but the text is changed within the quote. Why is
this happening and what can I do about it?

 

[swyck]

In Excel 2007, if I type the string ACN, it is automatically changed
to CAN.

I dont want that to happen and dont know how to turn that off. I
tried turning off auto-entry but that didnt work. I tried entering
the text in quotes, but the text is changed within the quote. Why is
this happening and what can I do about it?

Never mind. Found it under autocorrect options and was able to turn
it off there. I still think this is a goofy thing to set as a default
in a spreasheet which can have all sorts of variable strings.

 

[Bernard Liengme]

In Office the AutoCorrect applies to ALL the applications (Word, Excel,
PowerPoint...). Many of us have a tendency to hit the A before anything else
if we were not taught to type correctly. I often type AMY when I want MAY.
So ACN is likely a very common typo for CAN. For this reason MS included it
in Autocorrect. I am glad you found how to remove it but do realise that you
have also removed it from Word.
Best wishes

 

[Rick Rothstein \(MVP - VB\)]

Now, I don't know this for a fact, but I just tried it out in Excel and Word
and the AutoCorrect features appear to be separately applied. What I did was
this. In Excel, I click the Office Button and then clicked on the Excel
Options button, selected Proofing from the left-hand panel and clicked the
AutoCorrect Options button at the top of the right-hand panel, then I
unchecked the "Replace text as you type" Checkbox on the panel that
appeared. Finally, I OK'ed my way back to the spreadsheet. Next, I tried
typing "acn" into a cell and Excel did not correct it. Next, I called up
Word and type "acn" into the blank page and Word corrected it for me.
Following the same procedure as in Excel, I called up the AutoCorrect
Options and the "Replace text as you type" Checkbox was checked in Word.

Rick

 

[*alan*]

Not so. Autocorrect settings in Excel do not migrate to Word. (At least in
2003 versions)

 

[Dave Peterson]

You sure?

It does for me (also in Office 2003).

Not so. Autocorrect settings in Excel do not migrate to Word. (At least in
2003 versions)

 

[Gord Dibben]

Alan

I think you better do a test of your assumption.

My Office 2003 Pro Edition migrates ACL from Excel to Word and vice versa.


Gord Dibben MS Excel MVP

 

[*alan*]

Actually, it's not an assumption. It's an observation I made after I had
tested it.
In Excel 2003 (11.5612.5606) which I use, "acn" also autocorrected to "can".
The same autocorrection occurs with the Word 2003 (11.5604.5606).

In Excel, I went to Tools>Autocorrect Options, UN-checked the box labeled
"Replace text as you type". This disabled that autocorrection function.
"acn" stayed "acn".

I re-opened Word, typed in "acn" and it still autocorrected itself to "can".
The "Replace text as you type" remained checked as it had been.

Thinking that perhaps the "migration" would occur after a reboot, I
rebooted. Excel still does not replace acn with can. But Word continues to
do so.

I even tried making the autocorrections change with both Excel and Word open
at the same time. No difference.

I've absolutely no stake in misreporting my findings, and I'm rather puzzled
that both you and Dave Peterson report the opposite . . .

 

[Dave Peterson]

In xl2003, I added:

aaaaa replace with bbbbb

I closed excel and opened MSWord (2003). It was there.

I deleted it in MSWord. Closed MSWord.

Reopened xl and it was gone.

I use xl2003 11.8142.8132 SP2

But I don't think those build numbers and service pack changed any behavior.
IIRC, xl97, xl2k, xl2002 all worked the same way.

 

[Rick Rothstein \(MVP - VB\)]

I stand corrected... the AutoCorrect feature **IS** linked between the
Office 2007 products (well, at least between Excel and Word which is all I
tested). I performed the experiment Dave Peterson laid out in his second
posting in this thread and my results matched his. I think I got what I
reported because I didn't close the products down between testing (I had
both Excel 2007 and Word 2007 opened before I started my experiment).

Rick

 

[Rick Rothstein \(MVP - VB\)]

I was mistaken (and have now posted a correction) when I tested Word 2007
and Excel 2007 earlier. I just tried your experiment with them, just the way
you laid it out, and got the same results you did. The AutoCorrect feature
is linked across the Office 2007 products (well, at least for Word and Excel
which is all I tested).

Rick

 

[Gord Dibben]

What you have to do is remove the "acn" from the list which makes it unavailable
in Word also.

I'll bet Dave did that also.

"Replace as you type" setting disabled does not migrate to Word as you say but
that is not a member of the *.ACL file just an Excel-only setting.


Gord

 

[*alan*]

Dave, I repeated your experiment and got the same results that you did.

Perhaps you could repeat the experiment which I had described.

I never said that a modification of or addition to the "Replace text as you
type" function doesn't migrate from Excel to Word.

What I said was that disabling the "Replace text as you type" function does
not migrate from Excel to Word.

If you UN-check that box in Excel, it's going to remain checked in Word.

 

[Gord Dibben]

Rick

I also tested with Publisher, Outlook and Access.

Same ACL list and corrections.

See my post to OP regarding the "Replace as you type" setting.


Gord

 

[Dave Peterson]

Yep. Gord Dibben said the same thing.

Dave, I repeated your experiment and got the same results that you did.

Perhaps you could repeat the experiment which I had described.

I never said that a modification of or addition to the "Replace text as you
type" function doesn't migrate from Excel to Word.

What I said was that disabling the "Replace text as you type" function does
not migrate from Excel to Word.

If you UN-check that box in Excel, it's going to remain checked in Word.