Differences

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

--- public:faqs:excel_export [2016/11/30 18:44] – created kevin
+++ public:faqs:excel_export [2025/05/22 21:53] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Adding Speed-Quote to Excel Trust Center ======
+====== Problems Exporting Quotes to Excel ======
-Sometimes Excel will not allow you to export your Speed-Quote template. In order to fix this, you will need to add Speed-Quote files to the list of Trusted locations. You can not do this in Speed-Quote, you need to do it in Excel
+Speed-Quote needs to communicate with a local version of Microsoft Excel in order to export quotes to excel.  Sometimes Excel stops listening to Speed-Quote.  There are a number of reasons this may happen.  If Speed-Quote stops exporting quotes to excel, please try the following:
-====== Instructions ======
+===== A. Temporarily disable any security software on your computer =====
-) Make sure Speed-Quote is not running
+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.
-) Open a blank workbook in Excel
+===== B. Add Speed-Quote to Excel Trusted Locations =====
-) Select File -> Options -> Trust Center and then select Trust Center Settings
+More recent versions of Excel may need Speed-Quote to be added to Excels "Trusted Locations".  To do this follow these instructions:
-) When the window opens, select Trusted Locations and then select Add new location
+  - Make sure Speed-Quote is not running
+  - Open a blank workbook in Excel
+  - Select File -> Options -> Trust Center and then select Trust Center Settings
+  - When the window opens, select Trusted Locations and then select Add new location
+  - Add Speed-Quote Files
-) Add Speed-Quote Files
+===== 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.
+=== Repair Excel using the Control Panel ===
+  - Open the Control Panel -> Programs and Features window.
+  - Find Microsoft Office in the list of installed programs and highlight it.
+  - Click "Change" and then select "Repair" from the allowable options.
+  - Once that is finished try running Speed-Quote again and exporting to excel.
+=== Resetting the COM settings for Excel in the Windows Registry Settings ===
+Please note that making incorrect changes to the Windows Registry Settings can cause Windows to stop working.  If you are not sure what you are doing please ask a professional IT person.
+  - 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
+  - Rename this key to {00020813-0000-0000-C000-000000000046**.bak**}
+  - 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.