date filter in a pivot table


F

Finance-Phil

I have a pivot table created from data that includes dates. I have formated
the original data column of dates as dates and have the dates as the only
entry in my column data. Sometimes when I create the pivot table from new
data, I cannot filter the column data with date filters, it only allows me to
filter them as values. Even after I have gone into Pivot Table, Options,
Field Settings and changed the number formate to date and refreshed the Piot
Table, I still cannot filter using date filters (it is greyed out).
 
Ad

Advertisements

A

Andrew

I have a pivot table created from data that includes dates.  I have formated
the original data column of dates as dates and have the dates as the only
entry in my column data.  Sometimes when I create the pivot table from new
data, I cannot filter the column data with date filters, it only allows me to
filter them as values.  Even after I have gone into Pivot Table, Options,
Field Settings and changed the number formate to date and refreshed the Piot
Table, I still cannot filter using date filters (it is greyed out).

Hi,

I think it may be because this is an Excel 2007 feature. I had the
same problem with files saved as .xls but the date filters appear if
saved as .xlsx (Excel 2007)

Andy
 

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