Differences

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

--- public:faqs:excel_export [2017/01/05 19:06] – dave
+++ public:faqs:excel_export [2025/05/22 21:53] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 ===== A. Temporarily disable any security software on your computer =====
-Temporarily disable any security software on your computer (e.g. Norton, ESET, etc).  Sometimes an update to security software blocks the communication to Excel.  If disabling the security software fixes the problem, you will need to add an exemption for Speed-Quote in the security software.  Please see the instructions for your security software to see how to do this.
+Temporarily disable any security software on your computer (e.g. Norton, ESET, etc).  Sometimes an update to security software blocks the communication to Excel.  If disabling the security software fixes the problem, you will need to add an exemption for Speed-Quote in the security software.  Please see the instructions for your security software to see how to do this.  It is a good idea to add an exemption for Speed-Quote anyway.
 ===== B. Add Speed-Quote to Excel Trusted Locations =====
 More recent versions of Excel may need Speed-Quote to be added to Excels "Trusted Locations".  To do this follow these instructions:
   - Make sure Speed-Quote is not running
@@ Line 18: / 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 35: / Line 43: @@
   - Make sure Excel is NOT running.
   - Open the Windows Registry Editor (regedit.exe)
-  - Find the HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046} key
+  - Find the **HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}** key
-  - Rename this key to {00020813-0000-0000-C000-000000000046.bak}
+  - 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.