Troubleshooting
The Troubleshooting section contains information about common issues that exist while using the CloudConnector for Excel plugin.
Wolfram Cloud Test Problems
Instructions on how to use the Wolfram Cloud Test button are found in the Set Preferences in Excel section. Running the cloud test should give the following dialog if run successfully.
Any text highlighted in red is an issue that needs to be resolved for full operation of the CloudConnector for Excel.
Potential errors are described in the following.
No server was found at this address
If this error is shown, all other tests will fail as a consequence. There was no server found at the URL given for the Cloud Base. Please make sure that you are connected to the internet and that the Cloud Base is set correctly. See the Preferences section for more details.
Failed to identify as Wolfram Cloud
If this error is shown, a Wolfram Cloud is not found at the Cloud Base. Please make sure that the Cloud Base is set correctly. See the Preferences section for more details.
Your connection to the Wolfram Cloud cannot be verified
If this error is shown, a secure HTTPS connection cannot be made to the Wolfram Cloud. By default, the Wolfram Cloud requires a valid certificate to be installed on your system. However, you can disable this requirement with the Verify Security Certificates preference setting. See the Preferences section for more details.
Documentation examples are not installed
If this error is shown, the Wolfram Cloud you are connecting to does not have the documentation account correctly installed. Instructions for installation are found in Setup and Getting Started > Setup for Administrators.
Wolfram API Errors in Excel
The section outlines common errors you might see when using the WolframAPI and Wolfram functions in Excel. It provides likely reasons for these errors and how to resolve the issues. This section is intended to be used by both Excel users and developers.
API cannot be found
If you see this message, the CloudConnector has failed to find a Wolfram API with the given API name.
To check that the Wolfram API exists, use the Copy URL button to copy the URL to the clipboard. Enter this into a web browser and check for a response. If the API does not exist, you will get a 404 page.
Please verify that the API name is correct. See the API Name documentation for details.
If the problem persists, please contact your systems administrator or the owner of the API.
API cannot be accessed
If you see this message, the CloudConnecter cannot access the specified Wolfram API. This message occurs for two reasons:
2. You do not have permission to use the API.
If you are the owner of the API, you can check the reason by copying the URL with the Copy URL button. Paste the URL into a web browser, where you should be redirected to a sign-in page. When you sign in, if the API does not exist, you will get a 404 page. If the permissions need correcting, information can be found at Writing Wolfram APIs > Permissions.
API does not return a correctly formatted result
If you see this message, the CloudConnector received a response from the Wolfram API, but the data returned was unreadable.
The most likely cause is that the Wolfram API was not deployed with AllowedCloudExtraParameters set to All. Another cause could be the API Name specified is not a Wolfram API.
API result overlaps existing data
If you see this message, the Wolfram API is working correctly, but the data needs to expand to fill other cells that have data in them. Clicking the Go to button will reveal the API's target area. Remove any preexisting data from the target area and rerun the Wolfram API for correct expansion.
API has parameter errors
A WolframAPI typically has Parameters that are added to the Excel formula. If there is an issue regarding these parameters, you will receive errors accordingly. There are two types of errors that can be given.
Parameter "parameter name" is required
If you see this message, the "parameter name" has not been specified in the WolframAPI call. Double-check that this is contained in your WolframAPI formula.
Parameter "parameter name" cannot be interpreted from the input
If you see this message, the parameter was included in the WolframAPI call, but its value was not of the correct type. Clicking the More Info button will give its Interpreter type. Every Parameter has an Interpreter type, defining the type of data that it will accept. The following error outlines the type "Number", which must be a number.
It can be difficult to understand these Interpreter types if you are not a Wolfram Language developer. The owner of the API should be able to give you more information on what kind of data the parameter can take.
The WolframAPI function won't evaluate
Check that the Wolfram tab is on the Excel Ribbon. If this is not visible, the CloudConnector plugin is not installed or has been disabled. If it has been disabled, you should be able go to the add-ins dialog and enable the plugin. If you cannot see any reference to the CloudConnector in the add-ins dialog, a reinstall of the plugin will be required.
If the Wolfram tab is visible but still does not work, check that the APIsEnabled icon is red. If the icon is gray, the WolframAPI function will not operate. The icon should look like the following for APIs to work.
Your connection to the Wolfram Cloud cannot be verified
If you see this message, the security certificates to the Wolfram Cloud cannot be verified. The most likely reason is that you are accessing a Wolfram Enterprise Private Cloud that does not have security certificates. You can bypass certification by unchecking the Verify Security Certificates value in the Preferences.
The Introspector API has not been installed for the cloud account
If you see this message, the Introspector API has not been deployed on the cloud account that hosts the Wolfram API you wish to call. Only this owner can fix the issue by deploying the Introspector API. Details are found in Setup > Deploying the Introspector API.
To use the Wolfram function, you must be signed in to the Cloud
If you see this message, the Wolfram function was called, but you were not signed in. You need to sign in to the Wolfram Cloud and run the function again. See Setup > Signing In.
Example APIs are not working
If you are using Wolfram APIs from the Examples page and connecting to an Enterprise Private Cloud, you may find the examples do not execute correctly. This is most likely because the documentation account has not been created. Your administrator will be able to install this account, using the instructions found at Setup and Getting Started > Setup for Administrators.