However i can see it in Word.
Why is that missing? and how can i troubleshoot that?
For Excel 2007 you would select the excel button at the top left>look to the bottom of the pop-up menu for "Excel Options" and select>Add-Ins from left sidebar>select Go at the bottom next to the Manage Excel Add-Ins dropdown>select Browse (locate your Sforce-Connector folder you downloaded and open it to the sforce_connect.xla and highlight it)>click OK>make sure that Sforce_Connect has a checked box and select OK>select the Add-Ins tab and you will see the sforce Connector option.
My excel Version is 2007.
Yes i go to manage add-ins and browse salesforce.com
However i can't see any sforce_connect.xla (search for *.xla in the salesforce.com but could not see any)
Directory structure is as follows
Program Files\salesforce.com\Office Edition
Program Files\salesforce.com\Office Toolkit
And there are a number of Dlls, but no xla files.
Let me know if that does or does not work for you.
"An internal server erro has occured while processing your request. URL:/https://www.salesforce.com/services/Soap/c/2.5"
Anyone know how to fix this. Does it still worrk for you or did SFDC do something to disable the functionality?
be sure you are adding your security token after the password when logging in. If you don't have your token, you can get it by going to Setup | My Personal Information | Reset My Security Token
I get the same error message: "An internal server error has occurred while processing your request. URL:/https://www.salesforce.com/services/Soap/c/2.5", when I try to login with my Sandbox account. Then I try again with my Production account, it works correctly. It may be your issue too.
First I downloaded it from the website by going to My Username > My Profile > Desktop Add-Ons > Connect for Office and clicking "Install Now"
Initially it seems like the installation has taken place but when I open Excel I can't see the Salesforce.com tab
Next, I tried to go to http://code.google.com/p/excel-connector/downloads/list and I downloaded the connector, "sforce_connector_ee_1603.zip" (it seemed like the most recent one). I then unzipped it in the folder and tried to add it by going to "Manage Excel Add-Ins" in Excel and add this. However, I get a compile error when I'm doing this.
Is anyone else having similar difficulties? It looks like this thread died out mid-year last year so I'm wondering if people have given up or have figured it out. Would appreciate any help.
"Cannot run the macro C:\Users\etc,etc\sforce_connect.xla's DecribeAndQuery. The macro may not be available in this workbook or all macros may be disabled."