Date Formats not picked up in Pivot Table

[SpineyNorman]

Hello friends,

I have inherited a spreadsheet that I need to update soon. It takes data that has a date field and creates a pivot table by month. The person who created it completed it thru February. Now I have added data for March and April, but the pivot tables can not find this new data and I suspect it is because of the date formatting (I have done the Change Data Source under PivotTable Options to include all the new data).

The reason I suspect the date format is that she built a button to run a macro named "dateformat", which is not in the workbook. I have tired to manually format the date using the format painter from the February dates that the pibvot table recognizes, but I still get no results.

So I am at a loss. I realize this is somewhat of a vague question, but since I am a pivot table neophyte I thougth maybe someone could easily see the flaw that I am missing.

Thanks in advance. You guys have always bailed me out in the past.

 

[Andrew Poulsom]

After changing the data source did you refresh the pivot table?

 

[SpineyNorman]

Andrew -

A good question - yes I did without results - I should have mentioned that in the original question.

 

[Andrew Poulsom]

And what happens? Nothing at all? I find that unlikely.

 

[SpineyNorman]

I get an "empty" pivot table. When set to February I get all the data. When set to April, it all goes away. I don't know how to insert a picture, but I have a screen grab of an empty pivot table.