Pivot table problem

J

Joanne

Hi,

I am encountering some problem with pivot table's data
after i refreshed the pivot table.
I have a template with grouping and setting done, however,
when i paste new data into the raw data worksheet and
refresh the pivot table, the grouping in my pivot table
dissapear. But, when i check from the drop down box, i can
see my grouping but it doesn't appear in my pivot table.
Anyone know why?
 
P

Paul Falla

Dear Joanne
Could it be that in the new data that you add to your base
data table there are items which fall outside of the
groupings you have set?

I have had problems with this in the past, and have had to
ungroup and then regroup the data.
 

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

Top