tedcarbone / excel-connector

Automatically exported from code.google.com/p/excel-connector
0 stars 0 forks source link

"Invalid Range, missing data type..." error when querying currency fields #19

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
1. I create a new record that has a currency field 
2. The record gets created correctly incl. the currency field and its value
3. When querying the exact same record and with the fields that I just created, 
I get "Invalid Range, missing data type, or other error, type is: Account, Type 
mismatch"

I have been using excel connector a lot for a couple of years without any 
problems. Recently I started getting these errors with all currency fields. 
Upgrading to the most recent version (Winter11) of the Excel Connector did not 
help.

We use multicurrency in SF and have Professional Edition with API enabled. I 
have Win7 with Office 2007, Winter11 excel connector.

Original issue reported on code.google.com by david.ca...@gmail.com on 9 Feb 2011 at 11:30

GoogleCodeExporter commented 8 years ago
I'm getting the same issue sporatically, but for Inserting records.

Original comment by craigkun...@craigkunkle.com on 7 Nov 2011 at 5:42

GoogleCodeExporter commented 8 years ago
Try changing data type of currency fields in excel sheet by clicking on the 
currency cell go to home--> under number select Currency to General. That 
should work

Original comment by bharathi...@gmail.com on 5 Dec 2012 at 10:39

GoogleCodeExporter commented 8 years ago

Original comment by vneh...@gmail.com on 28 Jan 2013 at 5:11