You need to sign in to do that
Don't have an account?
wkuehler
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?