You need to sign in to do that
Don't have an account?
brkandivy
Excel Connector is not working
The first time I used connector (Office 2007) it worked fine. Now it won't work at all and I am getting this error message:
Cannot run the macro"c:\docume~1\dgarlock\LOCALS~1\Temp\Rar$DI00.813\sforce_connect.xla'!sDescribeAndQuery' The macro may not be available in this workbook or all macros by be disabled.
I have enabled all macros and the file is in this location. Not sure what else to do.
Hi,
I took copied this off of the Excel Connector SourceForge site.
___________
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.
_______________
Hope this helps,
Shaun
All Answers
Hi,
I took copied this off of the Excel Connector SourceForge site.
___________
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.
_______________
Hope this helps,
Shaun