Troubleshooting

Fusion loading issue after activation

../../../_images/fusion_not_running_page.png

If you encounter a loading issue after activating Fusion, it is most likely because the Fusion service server cannot be reached at the time that the Add-in is activated.

In order to resolve this issue, please check that the Fusion service has started and is running correctly.

Fusion asks for a valid license every time the Add-in is loaded

MS Excel has a strong web cache policy that can sometimes redirect Add-ins requests to its own cache. It does not send the Add-in activation request to Fusion to serve the Add-in service, but instead loads the last Add-in page that was available when it was activated.

To fix this behavior on a macOS:

  1. In a Finder window, go to ~/Library/Containers/com.Microsoft.OsfWebHost/Data/Library/Caches.
  2. In the Caches folder, delete the com.Microsoft.OsfWebHost folder.

Source

No notebooks are displayed in your notebooks list

If your Notebooks are not being displayed in your notebooks list:

  1. Verify that the notebooks files are in the Fusion notebooks folder–by default, the user home folder is ~/AnacondaFusion/notebooks.
  2. Verify that the notebooks are correctly being served at https://localhost:9888/.
  3. If both of the folders mentioned in the steps above contain the correct notebook files, please check your Fusion and Notebooks versions.

NOTE: Fusion version 0.9.0, and earlier, has a default configuration that will not work with notebook version 0.4.3, or later, due to a major change in the security policy of the Jupyter notebook server.

Notebooks added to the Fusion folder will not run

If you have added notebooks to the Fusion folder and they will not run:

  1. Upload the notebooks with the Fusion User Interface (UI).

  2. Run the notebooks in Jupyter before running them inside Excel with Fusion.

    NOTE: A notebook copied directly into the Fusion folder will not be trusted by Fusion and will not be able to run in Fusion.

Fusion on Windows is unavailable due to missing Add-ins

If, for some reason, Fusion was not granted administrator rights during installation and was not able to fully install all assets, Fusion will be unavailable on your local system.

To register the missing assets manually, take the following steps.

Sharing the folder containing the Fusion manifest

Excel Add-ins must be registered from either a Microsoft certificate store or from a network shared folder.

  1. Find the folder containing the manifest-anacondafusion.xml file.

  2. Open Windows Explorer and go to your home directory.

    EXAMPLE: A user with the account name “jsmith” would have a home directory of C:\Users\jsmith.

  3. In your home directory, locate the AnacondaFusion\ExcelPlugins folder and verify that it contains a file named “manifest-anacondafusion.xml”.

  4. Right-click the AnacondaFusion\ExcelPlugins folder, and select Properties.

  5. In the Properties window, click the Sharing tab.

  6. Click the Share... button.

  7. Verify that your user name is on the people to share with list.

  8. In the Name field type FusionShare.

  9. Click the Share button.

  10. Copy the network address of the folder, which you will use in a later step.

    EXAMPLE: \\DESKTOP-KC88P6N\FusionShare.

  11. Click the Done button.

  12. Close the Windows Explorer window.

Registering Fusion secure connection certificates

The Fusion Add-in is served through a local secure connection. This requires installing the security certificate:

  1. Click Start, and select Fusion to start the local Fusion server and display a command prompt that shows the server log.

  2. Open Internet Explorer and type https://localhost:5000 in the address bar:

    NOTE: Be sure to use Microsoft Internet Explorer or Edge, and not any other browser.

    ../../../_images/fusion_cert_1.png

  3. Click Continue to this website (not recommended).

    NOTE: This is safe for your computer, the reason it is not recommended is because you have not yet installed the security certificate.

  4. In the Security Alert, click the Yes button to proceed with the certificate installation:

    ../../../_images/fusion_cert_2.png

  5. In the browser address bar, click the the Fusion temporary certificate icon then click the Red Shield icon to view and install the certificate:

    ../../../_images/fusion_cert_3.png

  6. In the bottom of the Untrusted Certificate window, click View Certificates:

    ../../../_images/fusion_cert_4.png

  7. On the General tab, click the Install certificate button.

  8. Click the OK button:

    ../../../_images/fusion_cert_5.png

  9. In the Certificate Import Wizard window, select Local Machine and then click the Next button:

    ../../../_images/fusion_cert_6.png

  10. Select the Place all certificates in the following store check-box, then click the Browse button:

    ../../../_images/fusion_cert_7.png

  11. Select the Trusted Root Certification Authorities folder and click the OK button:

    ../../../_images/fusion_cert_8.png

  12. On the confirmation screen, click the Next botton:

    ../../../_images/fusion_cert_9.png

  13. In the Completing the Certificate Import Wizard, click the Finish button:

    ../../../_images/fusion_cert_10.png

  14. In the certificate confirmation window, click the OK button:

    ../../../_images/fusion_cert_11.png

Once complete, see Fusion is not displayed in the Windows Excel Add-ins view.

Fusion is not displayed in the Windows Excel Add-ins view

If Fusion is not displayed in the Windows Excel Add-ins view, the most likely issue is that the registration of the Fusion Excel Add-in manifest is missing.

To verify, and register, the Fusion Excel Add-in manifest:

  1. Open Excel.

  2. In the Excel toolbar, click File and select Options:

    ../../../_images/fusion_addin_1.png

  3. At the bottom left of the Excel Options window, select the Trust Center check-box.

  4. Click the Trust Center Settings button:

    ../../../_images/fusion_addin_2.png

  5. Select the Trusted Add-in Catalogs: field.

  6. In the Trusted Catalogs list, verify that the address of the network shared folder is listed and selected:

    NOTE: If it is not listed, type the address in the New Catalog Text field and click the Add Catalog button:

    ../../../_images/fusion_addin_3.png

    The following window is displayed:

    ../../../_images/fusion_addin_4.png

  7. Verify that the Show in Menu check-box is selected.

  8. Click the OK button.

  9. In the displayed notification that your settings are saved and will be applied when Office is restarted, click the OK button.

  10. Click the OK button to close the Excel Options window.

  11. Close and restart Excel to load the new Add-in.

  12. In the Excel ribbon, click the Insert tab then select My Add-ins:

    ../../../_images/fusion_addin_5.png

  13. In the Shared Folder section, select the Fusion Add-in–labeled as AnacondaExcel and click the OK button:

    ../../../_images/fusion_addin_6.png

Starting Fusion for the first time displays a FileNotFoundError

If, when you start fusion for the first time, you see a FileNotFoundError, you most likely did not restart Excel after your Fusion installation was complete.

NOTE: Excel must be opened at least once before starting Fusion.

To resolve this issue:

  1. Open Excel.
  2. Close Excel.
  3. Restart Fusion.

Other Issues

If you have any questions or problems with Fusion, and you are a current Enterprise subscriber, please contact your support representative.