I have used the excel connector for about 6 months with Excel 2003 then 2007 sucessfully.
Recently I have bben getting this error when I try any button from the EC toolbar:
'sforce_connect_for_pe1.htm' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
I don't recall any system changes other then the security tokens. I have deleted & readded the add-on and run the Excel diagnostics.
Anyone know what is wrong or something else to try? Thanks, Karissa
Does anyone know of an online spreadsheet that works like The Excel Connector? I need the functionality of 2 people working a one spreadshet AND it changing the content IN SalesForce and is availible from any where. I have tried EditGrid but it is not seeming to be the right thing. Why oh why can't SalesForce just have it for the reports is beyond me....
I had difficulty installing and it worked for an hour or so. Now I'm getting one of two errors:
When I start the Connector from the menu on the Add-Ins tab:
Cannot run the macro ''C:\Documents and Settings\sglickman\Desktop\sforce_connect_for_pe.xla'!sfDescribeAndQuery'. The macro may not be available in this workbook or all macros may be disabled.
Note that I do have all macros enabled (in the Excel 2007 Trust Center)
If I were to open Excel by clicking on the sforce_connect_for_pe.xla file on my desktop (No other Excel sessions were running:
A document with the name 'sforce_connect_for_pe.xla' is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents.
I would really appreciate help from anybody out there that may have experienced the same problems. I'm using Professional Edition with Excel Office 2007.
I have used the excel connector for about 6 months with Excel 2003 then 2007 sucessfully.
Recently I have bben getting this error when I try any button from the EC toolbar:
'sforce_connect_for_pe1.htm' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
I don't recall any system changes other then the security tokens. I have deleted & readded the add-on and run the Excel diagnostics.
Anyone know what is wrong or something else to try? Thanks, Karissa
