Excel cannot group by numeric or date intervals in fields with bl.

Y

yeokphong

When I clicked the export to Excel button at Pivot table, it's give me "Excel
cannot group by numeric or date intervals in fields with blank or missing
data. Grouping information for some fields may be lost.". I found the date
fields have blank data for Date By Month (for the Date, it's come out
automatically Date, Date By Week, and Date By Month). If really blank data,
how come it's cannot export to Excel? Why? Does have any suggestion to
resolve this problem? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top