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?
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.