How do I group new pivottable data w/old data instead of >5/31/08

C

craigc

I have a pivot table report that shows sales by month. I update it with new
data monthly. My problem is that the newest month is showing up under the
title heading >5/31/2008 instead of June. All of the other months have the
correct monthly title heading. This is annoying. Anybody know what's up?
craig
 

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

Similar Threads

Using pivot tables to group records (with daily transactions) bymonth 2
How do I get all 5 graph charts to show data (not be greyed out)? 1
Make manually changed pivot table column headings work for other u 0
Function, array, query What do I need? 1
Pivot Table External Data % Problem 8
Totals in crosstab query 0
How do I get old rows to auto delete when new are added? 1
Print tab for each page field in PivotTable 1

Top