+ Start a Discussion
wkuehlerwkuehler 

Excel SOQL_Table formula issue

Not sure why this is happening.  When I save an excel spreadsheet that contains sforce connector formulas, the formulas are changed after the document is opened.
 
For example,
 
=IF(C16="","", soql_table("User","UserName = '" & C16 & "'"))
 
is changed to
 
=IF(C16="","", 'C:\Documents and Settings\username\My Documents\Programs\sforce_connect.xla'!soql_table("User","UserName = '" & C16 & "'"))
 
and the sheet no longer works.
 
Any ideas?