function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
DonniDonni 

Error trying to login to add sforce connector (excel connector)

When I try to log into the connector, it gives me the following message:

"` `Sforce_connect_for_pe.xla could not be located. Check the spelling of the file name and its location is correct. If you are trying to open the file from your list of recently used files, make sure it has not been renamed, moved or dropped. "
rhizomerhizome

Could it be this problem I found in the Excel Connector documentation? http://sforce.sourceforge.net/excel/faq.htm copied down below...

 

Question
I got the excel connector installed properly yesterday. But I noticed that I had saved it to a temporary folder, so I moved the .xla file to a different folder. Once I did that, whenever I tried to open the .xla file, it says that "the file could not be found. Check the spelling of the file name, and verify that the file location is correct." How can I uninstall, and reinstall all over again?

Answer
Yes, if you move the file you may have to uninstall the entry in the Add-In list of Excel and re-install it from the new location. This sounds easy, but it can be tricky because Excel thinks the old file exists until you really clear out the toolbar and entry from the add-in folder 
I use steps like this: 
     Open Excel 
     click Tools, Add-Ins 
     uncheck the sforce_connect checkbox, click OK 
     close Excel 
     Open Excel again, if the "sforce_connector" menu bar is still there, right click on the tool bar area of excel, uncheck the sforce Connector check box 
     close Excel 
     open Excel 
     If the bar is gone and the Add-INs list is showing the add-in as unchecked or gone then you can re-install the add-in using the new file location of the XLA, see the install instructions Installation Guide for details on the install.

I wish i could tell you a better way to do this, but these steps work most of the time.