+ Start a Discussion
BingBing 

Puzzled Excel Connector issue: only partial records of a table are retrieved

I have a SFDC country table with 216 records. I can see all of them in SFDC list view (this proves that I have access) and I can also extract them via Jitterbit dataloader.

 

However, when I use Excel Connector, this is what happened:

 

1) If I use "Table Query WIzard" or "Query Table Data", without any filder, then only 13 records returned

 

2) If I paste all record ID in excel,  use "Query Selected Rows", then it does retrieve data of all rows.

 

I tried several times. It always the same 13 records. (I could see any pattern from the 13 records)

 

I am using the latest Excel Connection (Version 16.03).  I did not have this problem before and also don't have problem today with other tables.  I have full SFDC admin access

 

Bing

 

Please kindly shed some lights

jacek2jacekjacek2jacek

I have the same problems.

i've noticed that if i update record (eg.lead) it becomes visible in excell query results.

all new records are visible in excell query results.

Bing MaletzBing Maletz

Jacek2jacek, thanks for sharing the solution.