I am using ImportDataView to populate a spreadsheet and it works great, but a number field and date field does not show in the spreedsheet (the rest do show up) when formatting is applied to the template spreadsheet that is used to receive the data. If I direct the output to a blank unformatted sheet in the same workbook, all the data fields show.
The template sheet was working, but once I applied formating so the date shows as a date, then it stopped.
Have you heard of this happening before and how can I fix?