Values not appearing in linked Excel table

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?

Find more posts tagged with

Sheets

Reports

Project Management

Importing and Exporting

Comments

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.