T
Tom H
I've created a pivot table report where I update the data
on a regular basis with a large query text file(8MB). My
problem is that the prior month row grouping headings
still appear in the drop down box along with the current
month's groupings, even after I refresh the table. I know
the data doesn't exist in the table because I can deselect
the show all and filter on the a prior month grouping and
nothing appears. What is really strange is that if I move
the row up into the page area, all I see is the current
month headings as I would expect. If I create a new pivot
table I don't have this problem. I don't want to have to
create a new pivot table each time as I would have to add
the formulas and formatting. Any suggestions? I
on a regular basis with a large query text file(8MB). My
problem is that the prior month row grouping headings
still appear in the drop down box along with the current
month's groupings, even after I refresh the table. I know
the data doesn't exist in the table because I can deselect
the show all and filter on the a prior month grouping and
nothing appears. What is really strange is that if I move
the row up into the page area, all I see is the current
month headings as I would expect. If I create a new pivot
table I don't have this problem. I don't want to have to
create a new pivot table each time as I would have to add
the formulas and formatting. Any suggestions? I