Values not appearing in linked Excel table

ZK

I have a report that pulls from several Smartsheets. When I run the report in Smartsheet, I see all my values appearing. However when I refresh the linked report in Excel, not all the values appear. My values are text/number so there is room for numbers as well as "N/A" -which we manually enter. 

 

I have another, very similar column (same properties and similar values, including N/A)... everything appears in the report view in Smartsheet, as well as the linked Excel table.

 

There is no apparent difference between the two columns.

 

Any suggestions?

Shaine Greenwood

Hi ZK,

 

I'm assuming that you're using the Data Connector (ODBC driver) to get data to populate in your Excel table. I'd recommend contacting our Support team to troubleshoot this issue further.