Differences

This shows you the differences between two versions of the page.

--- public:faqs:excel_export [2017/01/05 19:07] – dave
+++ public:faqs:excel_export [2025/05/22 21:53] (current) – external edit 127.0.0.1
@@ Line 17: / Line 17: @@
   - Add Speed-Quote Files
-===== C. Reset Excels COM settings in the Registry Editor =====
+===== C. Make sure the LCID is correct =====
+  - Open the "Apptastic Registry Editor" from the Windows Start Menu
+  - Click on the "Client Prefs" in the left side bar and write down the number that shows beside "Excel LCID" (e.g. 2057)
+  - Open "C:\Program Files\Microsoft Office\" (or "C:\Program Files (x86)\Microsoft Office\" for 32bit office) in File Explorer
+  - Duplicate the 1033 folder and name the copy the same as the "Excel LCID" found previously (e.g. 2057)
+  - Copy and Paste Excel.exe into that new folder and rename it xllex.dll
+===== D. Reset Excels COM settings in the Registry Editor =====
 Sometimes the settings for communication with Excel can become corrupted in the Windows Registry Editor.  Here are 2 sets of instructions to try to fix this.
@@ Line 36: / Line 45: @@
   - Find the **HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}** key
   - Rename this key to {00020813-0000-0000-C000-000000000046**.bak**}
-  - Open Excel and it should recreate the previous key with the proper settings.
+  - Repair Office again with the above instructions and check to see that the key was recreated.  You may need to refresh the registry editor to see any changes.