Problem with pivot table's grouping when raw data being refreshed

J

Joanne

Hi,

I need some help here regarding pivot table.
I am generating some reports by using Excel pivot table on
daily basis. I will cut the new data and paste it into the
previous file and refresh the pivot table. However, when i
refresh the pivot table, all the grouping that i did
previously will lost. But when i look from the drop down
box, i can see the previous grouping but it won't display
on the excel spreadsheet.
Anyone know why?
 

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

Pivot table report invalid 0
Excel 2013 Pivot Data Range formula reference problem 0
Pivot Table Source file 2
SUM & OFFSET & PIVOT TABLE?? 0
Getpivot data not referencing properly 0
Multiple Pivot Tables Expand to Fit 0
How to base a pivot table on another pivot table? 3
Automatically update pivot table when switching to sheet that thepivot table is in 4

Top