Prev: Excel 2007 file locked by 'another user' on windows 2008 share
Next: How to save files in the formats of *.csv(MS-DOS) in Excel 2003
From: Finance-Phil on 10 Dec 2009 16:45
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).
 | 
Pages: 1
Prev: Excel 2007 file locked by 'another user' on windows 2008 share
Next: How to save files in the formats of *.csv(MS-DOS) in Excel 2003