User Tools

Site Tools


public:faqs:excel_export

This is an old revision of the document!


Problems Exporting Quotes to 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:

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.

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:

  1. Make sure Speed-Quote is not running
  2. Open a blank workbook in Excel
  3. Select File → Options → Trust Center and then select Trust Center Settings
  4. When the window opens, select Trusted Locations and then select Add new location
  5. Add Speed-Quote Files

C. 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

  1. Open the Control Panel → Programs and Features window.
  2. Find Microsoft Office in the list of installed programs and highlight it.
  3. Click “Change” and then select “Repair” from the allowable options.
  4. 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.

  1. Make sure Excel is NOT running.
  2. Open the Windows Registry Editor (regedit.exe)
  3. Find the HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046} key
  4. Rename this key to {00020813-0000-0000-C000-000000000046.bak}
  5. Open Excel and it should recreate the previous key with the proper settings.
public/faqs/excel_export.1483643181.txt.gz · Last modified: (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki