--- title: "Troubleshooting FAQ" slug: "troubleshooting-faq" description: "Fixes for common problems, including the SQL Spreads add-in not appearing in Excel and how to repair the installation." updated: 2026-11-05T17:56:25Z published: 2026-11-05T17:56:25Z canonical: "sqlspreads.com/troubleshooting-faq" --- > ## Documentation Index > Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Troubleshooting FAQ ### The SQL Spreads Add-In does not show up in Excel #### **Solution #1:** Repair the SQL Spreads installation: 1. Type **Control Panel** in Windows search bar ![Image](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image(281).png) 2. Go to **Programs** and click **Uninstall a program** ![Image](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image(282).png) 3. Select the **Obnex SQL Spreads** and click **Repair** ![Image](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image(283).png) 4. Restart Excel and the SQL Spreads Add-In should show up again. #### **Solution #2:** Enable the Add-in Excel Options: 1. In search field at the top of Excel, type and select COM Add-ins ![Image](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image(285).png) 2. Locate and check the **SQL Spreads Add-In** and click **OK**. ![Image](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image(286).png) 3. The Add-In should now show up in Excel. If you do not see the SQL Spreads Add-In in the list: 4. In **Excel** go to the **File menu** and select **Options** at the bottom 5. In the **Excel Options** dialog, select the **Add-ins tab** 6. At the bottom of the tab, in the **Manage** drop-down list, select the **Disabled Items** ![Image](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image(288).png) 7. If the **SQL Spreads Add-In** is in the list, select it and click **Enable**. ### Generate Diagnostic file for troubleshooting issues From version 7.6, there will be a new troubleshooting option that is available - the ability to generate a SQL Spreads Diagnostic File. This will collect anonymized setup details to help improve and expedite support interactions. It is found in the Help section in the SQL Spreads ribbon. ![Generate SQL Spreads diagnostic file option in Help section](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Generate%20SQL%20Spreads%20diagnostic%20file.PNG) ### Create a log file for Excel Add-In loading issues If you experience issues with the SQL Spreads Excel Add-In not loading either from time to time or permanently, you can enable a special startup logging and send that log file to us for investigation. #### Enable startup logging from within the SQL Spreads Excel Add-In If you experience this issue from time to time, go to the SQL Spreads tab in Excel and select Help > Application Settings. Then check the **Enable Add-In startup logging** checkbox: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28178%29.png) When the issue has occurred and the SQL Spreads tab is missing, go to the folder *C:\Users\ [YourWindowsUserName]\ AppData\Local\Obnex Technologies AB\SQL Spreads Desktop* and look for the file **SQLSpreads Add In.vsto.log** ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28179%29.png) Send the file to support@sqlspreads.com #### Enable startup logging when you cannot access the SQL Spreads Excel Add-In If something goes wrong during the loading of an Excel Add-In, Excel can create a log with detailed info about the issue.This logging is enabled by adding a new environment variable on the PC having the issue. Follow the instructions below to enable this startup logging: 1. If you are using Windows 10, open the Windows search field and type **Environment variables** Then go directly to step 6. 2. Otherwise, go to the Control Panel in the Windows Start menu or type Control Panel in the Windows search box (the magnifying glass in the bottom left corner in Windows) 3. Click **System** and **Security** 4. Click **System** 5. Click **Change Settings** 6. Go to the **Advanced** tab and click the button **Environment variables** 7. In the top section named **“User variables for...”**, click the **New**... button 8. Under Variable Name, enter **VSTO_LOGALERTS** and set the Variable Value to **1** 9. Then restart Excel. 10. If the SQL Spreads tab is not shown, enable the SQL Spreads Add-In under File > Options > AddIns, and then restart Excel. See this article for more details. 11. When the issue has occurred and the SQL Spreads tab is missing, go to the folder ***C:\Users\ [YourWIndowsUserName]\ AppData\Local\Obnex Technologies AB\SQL Spreads Desktop*** and look for the file SQLSpreads Add In.vsto.log 12. Send the file to [support@sqlspreads.com](mailto:support@sqlspreads.com) ### Error message during Excel startup: "The solution cannot be installed because it is signed by..." When starting Excel after installing SQL Spreads an error message is shown with the following information: "The solution cannot be installed because it is signed by a publisher whom you have not yet chosen to trust." ![TrustedPublisher1.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisher1.png) #### Solution: Your environment requires that you add SQL Spreads/Obnex Technologies as a Trusted Publishers in Windows. Please follow the steps in the answer below [Adding SQL Spreads/Obnex Technologies as a Trusted Publisher](/docs/troubleshooting-faq#addingsqlspreadsobnextechnologiesasatrustedpublisher) ### Adding SQL Spreads/Obnex Technologies as a Trusted Publisher To add Spreads/Obnex Technologies as a Trusted Publisher, you will have to add the SQL Spreads/Obnex Technologies certificate into the Trusted Publishers in the Windows certificate store. To do that, follow these steps: 1. Close all Excel windows. 2. Download the SQL Spreads/Obnex Technologies certificate for the SQL Spreads release you use from here [Certificate for SQL Spreads 7.4.1 (Latest)](/downloads/certificates/SQLSpreadsCertificate_7.4.1_260928.zip) [Certificate for SQL Spreads 7.3.0 or earlier](/downloads/certificates/SQLSpreadsCertificate_before_7.4.10_260928.zip) [Certificate for SQL Spreads 6.0.17 or earlier](/downloads/certificates/SQLSpreadsCertificate_before_6.0.30_260928.zip) 3. Right-click the downloaded certificate file and select **Install Certificate**: ![TrustedPublisher2b.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisher2b.png) 4. Select the **Current User** option: ![TrustedPublisher6.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisher6.png) 5. Select **Place all certificates in the following store** and click **Browse** ![TrustedPublisher7.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisher7.png) 6. Select **Trusted Publisher** and click **OK**: ![TrustedPublisher8.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisher8.png) 7. In the Certificate Import Wizard, click Next and then Finish and you will now get a confirmation message that the certificate was Successfully installed. 8. If the warning was shown during installation, bring up the Installer window from the program bar and click **Install** to continue. ![TrustedPublisherContinue.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisherContinue.png) 9. If the warning was shown when starting Excel, close Excel and go to the **Control Panel** and select **Programs** > **Uninstall Program** ![TrustedPublisher9.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisher9.png) 10. Select **Obnex SQL Spreads** in the list and click **Repair** at the top: ![TrustedPublisher10.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/TrustedPublisher10.png) 11. Now restart Excel and you should see the SQL Spreads Excel Add-In in the top of Excel. ### The Design mode button is grayed out after I've upgraded office In the SQL Spreads tab in Excel, I cannot click the Design mode button as it is grayed out. #### Solution: Please [uninstall](/docs/installing-sql-spreads#uninstallingsqlspreads) and [reinstall](/docs/installing-sql-spreads) the SQL Spreads Excel AddIn. You can reuse the same Activation Key as long as you have not changed to a new machine. Check that you have not activated the Data Editor mode license key instead of the Design mode license key. ### 32-bit/64-bit warning when using the per-machine installer During the start of Excel, the following error dialog is shown: ![Error 32-bit.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Error%2032-bit.png) #### Solution: Note: This applies only to the Per-Machine installer. 1. Uninstall SQL Spreads by following this [step by step guide](/docs/installing-sql-spreads#uninstallingsqlspreads). 2. Run the SQL Spreads installer. 3. During the installation, you will be asked to select if you have the 32-bit or the 64-bit version of Excel installed. ![32-bit installation.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/32-bit%20installation.png) 4. If you are not sure which version of Excel you are running, open Excel and click the **File** menu in the top left corner. Then select **Account** and click the **About** button on the right side. ![About excel.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/About%20excel.png) 5. In the dialog you will find the version at the end of the first row: ![64-bit.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/64-bit.png) ### How to disable FIPS Encryption On some Windows environment configurations, you may see an error message saying that FIPS encryption must be disabled. To correct this you will need to disable the "Local Security Setting System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing" policy in Windows. 1. Go to **Control Panel** > **Administrative tools** 2. Select **Local Security Policy** - The Group Policy dialog appears. 3. Under the **Local Policies** heading, select **Security Options**. 4. Locate the “System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing” setting in the right pane and double-click it. 5. Set the setting to “Disabled” and click **OK**.