+ Start a Discussion

Change the connected environment

After installing the Excel connector, now from Excel I can only connect to the Salesforce Production environment. Does any expert know how to change the connection if I want to connect to my Sandbox environment?
Best regards!
When logging into the connector, press the Advanced button.  Doing so will let you enter the endpoint URL for your Sandbox. 
I use the Excel Connector frequesntly to upload and manipulate data in our sandbox:
1. Click on Advanced when you login
2. Change the URL to point to your Sandbox location. (I typically also change the Soap version to 9.0)
2. Append your Sandbox name after your normal user name ie johnsmith@google.com.googlesandbox
3. Append your security token after your password

Hope this helps