Differences

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

--- public:faqs:excel_export [2017/01/05 19:21] – 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.