Pivot table date filter disappears after updating source data

[JohnB123]

Hi,

Working in excel 2007. I have set up a pivot table to view sales figures.

I download the data from an sql server and then have to run a text to columns operation so that the date is in the correct format and an can be sorted.

When I built the pivot table from scratch, when I chose to filter by 'Creation date' there was no issue and I could select data from this year, last month, this week-no problem. I test once or twice pasting in the data and seemed to have no issue. When i tried this week, the date filter is no longer possible, I can now just see label filters.

I have tried, formatting the source data in other ways but to no avail. I can filter the souce data by date with no issue but for some reason the date filters are not working on the pt.

Please help.

 

[JohnB123]

Ok, So I found the answer. If you have this problem, ensure there are no blanks in your column of dates otherwise excel will think it is a value and not a date.

 

[LCarney]

Ok, So I found the answer. If you have this problem, ensure there are no blanks in your column of dates otherwise excel will think it is a value and not a date.

THANK YOU! I was going nuts and that fixed it!