error message: no Object Id found in the column header row

[GoogleCodeExporter]

Hi,
I have install the Connector last year and it was working perfectly (it's a 
great tool!), but suddently I am not able any more to use it again. For any 
attemp I try (for instance, using the option Insert selected row), I 
systematically get the two following error messages:

Microsoft Excel
---------------------------
no Object Id found in the column header row
---------------------------
OK   

and once I click OK I get: 

Salesforce Excel Add-In
---------------------------
Salesforce: Query() 
invalid Range, missing data type, or other error, 
type is: Asset
Application-defined or object-defined error
---------------------------
OK   

If I send my file to a colleague, he has no problem to create assets thus using 
it.

I have tried to uninstall the SForce Office Toolkit, remove the Excel-Connector 
and then install again everything, I have tried both versions of the connector 
(Winter 11 and EE one), nothing changes, I always get these both messages.

OS: Windows XP SP3
Connector version currently installed: 16.02 - 11/23/2010 (but I have tried 
several)
sforce Toolkit for Office currently installed: V4.0
MS Excel 2007
SalesForace.com 11 (I do not remember if we are on the professional or 
Enterprise Edition.

I hope You get all the information needed.
Please do you have any idea on how to solve my problem?

Thanks
Mariline

Original issue reported on code.google.com by mballest...@gmail.com on 1 Apr 2011 at 1:27

[GoogleCodeExporter]

Hi Mariline,

I had the same issue, and it looks like the Query is case sensitive here. If 
you"ve entered "ID", replace by "Id" and it will work.

Pete.

Original comment by lem...@gmail.com on 8 Apr 2011 at 2:00

[GoogleCodeExporter]

Hi Pete,

I have tried to replace my type "id" in "Id" (in the Asset and Asset ID cells) 
and I'm still getting the same error messages. I even tried to modify the cells 
name...

I am sending you my original file (with the "id" and not "Id"). Could you 
please have a look at it and see if you can see something wrong? I do not know 
if you have a way to test it...

Anyway, many thanks for your help.

Mariline

Original comment by mballest...@gmail.com on 11 Apr 2011 at 8:42

[GoogleCodeExporter]

Hi,

It isn't linked to my files, neither to my computer configuration. I have the 
confirmation. It seems to be linked to my SalesForce account. With any other 
account everything is going well, with mine, we get systematically the error 
messages.
In SalesForce, I am an administrator, I have compare my personal configuration 
with users who succeed in importing assets, and I cannot see differences.

Do you have any idea on the wrong settings of my account that could cause this 
issue?

Thanks - Mariline

Original comment by mballest...@gmail.com on 21 Apr 2011 at 1:58

[GoogleCodeExporter]

I'm getting the same issue when I've used the Force.com Connector extensively 
for a long period of time.  It seems limited to one particular worksheet as I 
have multiple ones that were updated and most until the current one had no 
issue.  So I assume it has something to do with the data in this particular 
sheet and not my Salesforce account or the connector in general.    I do have 
the appropriate names in the header row as they were put there by the Connector 
itself.   I deleted all the text in row 1, above the table, (aside from 
Opportunity) as that sometimes causes issues.   Thoughts on other reasons this 
won't work?  It is happening on multiple cells in multiple columns in the same 
worksheet. 

Original comment by elizabet...@gmail.com on 10 Apr 2013 at 4:08

[GoogleCodeExporter]

I'm getting the same issue when I've used the Force.com Connector extensively 
for a long period of time.  It seems limited to one particular worksheet as I 
have multiple ones that were updated and most until the current one had no 
issue.  So I assume it has something to do with the data in this particular 
sheet and not my Salesforce account or the connector in general.    I do have 
the appropriate names in the header row as they were put there by the Connector 
itself.   I deleted all the text in row 1, above the table, (aside from 
Opportunity) as that sometimes causes issues.   Thoughts on other reasons this 
won't work?  It is happening on multiple cells in multiple columns in the same 
worksheet. 

Original comment by elizabet...@gmail.com on 10 Apr 2013 at 4:08