Excel – How to add / upload bulk entries to Excel 2010 Autocorrect

microsoft-excel-2010vba

I currently have about 200 entries of autocorrect but it's painful to add one by one manually to "autocorrect" (File > Options > Proofing > AutoCorrect Options > AutoCorrect tab). These entries are phrases for long piece of text e.g. ROI = Return Of Investment etc.

Is there any way to upload these entries quickly ?

Best Answer

  • You will need to add them to the .acl file as explained in this KB.

    To use your AutoCorrect entries on another computer (or to share them with another user profile on your computer), locate the .acl files in the %AppData%\Microsoft\Office folder. (You can type the path in Windows Explorer exactly as shown here and the %AppData% environment variable will automatically expand to the full path. In Windows 7, that path is C:\Users\username\AppData\Roaming\Microsoft\Office by default, but it might be different on your computer.)

    Note, this may interfere with your other template settings -

    You cannot extract and copy only the AutoCorrect entries. And if you copy and paste the entire file, you will replace the styles and other items in the template file that you overwrite.

    In other words, this is possible, but not easily done.

  • Related Question