Forum Discussion

shaun_duggan's avatar
shaun_duggan
Copper Contributor
Dec 14, 2023

Smart sheet hyperlink connection issue

Hello,

 

I am having issues connecting MS Excel (365) to Smartsheet's. I keep receiving the error message, "The connection string is invalid. Format of the initialization string does not conform to specification starting at index 0."

 

Could someone please reach out and we can walk through this process together?

 

Thank you,

Shaun

excel
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Dec 18, 2023

    shaun_duggan 

    The error message "The connection string is invalid. Format of the initialization string does not conform to specification starting at index 0" typically indicates an issue with the connection details or the format of the connection string.

    Here are some steps you can take to troubleshoot and potentially resolve the issue:

    1. Check Connection Details:

    Verify that the connection details, such as server address, credentials, and any other required information, are correct.

    Ensure that the Smartsheet API key or access token (if applicable) is valid.

    2. Update Connection String:

    If you are using a connection string, review it for any syntax errors or typos. It should be formatted correctly according to the specifications.

    3. Recreate the Connection:

    Try recreating the connection in MS Excel 365. Delete the existing connection and set up a new one with the correct details.

    4. Firewall and Network Issues:

    Check if there are any firewall or network restrictions preventing the connection. Ensure that the necessary ports are open.

    5. Update MS Excel 365:

    Ensure that your MS Excel 365 is up to date. Check for any available updates and install them.

    6. Smartsheet API Status:

    Check the status of the Smartsheet API to see if there are any ongoing issues or maintenance that could be affecting the connection.

    7. Smartsheet Support:

    Reach out to Smartsheet support for assistance. They can provide guidance on specific issues related to connecting Smartsheet with MS Excel 365.

    8. Consult Documentation:

    Refer to the documentation provided by Smartsheet for connecting with external applications, and ensure that you are following the recommended steps.

    9. Test in a Different Environment:

    If possible, try setting up the connection in a different environment to see if the issue persists. This can help determine if the problem is specific to your current setup.

     

    Remember to handle sensitive information securely, especially when sharing details related to API keys or access tokens. The text and steps were edited with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark as best response and Like it!

    This will help all forum participants.

Resources