 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007My entries are being changed!
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? > In Excel 2007, if I type the string ACN, it is automatically changed > to CAN. [quoted text clipped - 3 lines] > 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. 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  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email >> In Excel 2007, if I type the string ACN, it is automatically changed >> to CAN. [quoted text clipped - 7 lines] > 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. 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 > In Office the AutoCorrect applies to ALL the applications (Word, Excel, > PowerPoint...). Many of us have a tendency to hit the A before anything [quoted text clipped - 14 lines] >> 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. 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 > 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 [quoted text clipped - 28 lines] >>> 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. 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 On Sun, 29 Jul 2007 20:55:17 -0400, "Rick Rothstein \(MVP - VB\)" <rickNOSPAMnews@NOSPAMcomcast.net> wrote: >I stand corrected... the AutoCorrect feature **IS** linked between the >Office 2007 products (well, at least between Excel and Word which is all I [quoted text clipped - 37 lines] >>>> 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. Not so. Autocorrect settings in Excel do not migrate to Word. (At least in 2003 versions) > In Office the AutoCorrect applies to ALL the applications (Word, Excel, > PowerPoint...). Many of us have a tendency to hit the A before anything [quoted text clipped - 14 lines] >> 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. 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) [quoted text clipped - 23 lines] > >> 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. SignatureDave Peterson 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 >Not so. Autocorrect settings in Excel do not migrate to Word. (At least in >2003 versions) [quoted text clipped - 17 lines] >>> 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. 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 . . . -- Alan > Alan > [quoted text clipped - 27 lines] >>>> 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. 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. > Actually, it's not an assumption. It's an observation I made after I had > tested it. [quoted text clipped - 57 lines] > >>>> 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. SignatureDave Peterson 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 > In xl2003, I added: > [quoted text clipped - 86 lines] >> >>>> default >> >>>> in a spreasheet which can have all sorts of variable strings. 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. -- Alan > In xl2003, I added: > [quoted text clipped - 86 lines] >> >>>> default >> >>>> in a spreasheet which can have all sorts of variable strings. Yep. Gord Dibben said the same thing. > Dave, I repeated your experiment and got the same results that you did. > [quoted text clipped - 105 lines] > > > > Dave Peterson SignatureDave Peterson 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 >Actually, it's not an assumption. It's an observation I made after I had >tested it. [quoted text clipped - 17 lines] >I've absolutely no stake in misreporting my findings, and I'm rather puzzled >that both you and Dave Peterson report the opposite . . .
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.