Excel Live Data Connector - Partial Results Returned
On Smartsheet the report returns all rows. When I export to excel it returns all rows. When I run the connector in Excel, it excludes some rows.
It appears that the rows being excluded have a Text/Number value in column X i.e. D21, whereas the ones being returned just contain a number in column X i.e. 1901 - so I wonder if it's something to do with Data retrieval mode??
I have changed the connector settings to "Always Return Text" and tried the "Use entirety rule". Is there anything else I can try?