Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table grouping issues
I have what seems to be an impossible question to find answers on... but
here goes: Background: I have workbook with multiple pivot tables. All pivot tables are linked so if you refresh one, you refresh them all. I have a tremendous amount of data being pulled in, approx 5000 rows, with 47 columns of data. 3 of those columns are formulas in excel that are updated based on certain data being present. Data is updated every day, and can be more than 5000 rows or less, it is constantly fluctuating. I have a dynamic named data range so I don't have to keep changing all the pivots / formulas. On each pivot table, I have groups set up based on specific fields. Problem: Grouping.... I used to be able to ungroup my selections, refresh my pivot tables and regroup the same selections using the same name. My computer was recently rebuilt, and now I seem to have lost that option. When I ungroup my selections, the entire column disappears. This never used to happen before. I don't necessarily want to have this option back, my overall question is whether there is a way to keep the grouping intact and have it update with the refresh and not disappear every time? I've looked through many websited and at least 100 posts on this website and have found nothing even remotely similar. Is there anyone that has run into this before or am I just being cursed for making complicated excel pivots? :-( Any ideas (excluding adding another formula to the data) is greatly appreciated. Also... because i've seen countless posts with this problem listing... I do not have errors grouping. I can group just fine, it just doesn't stick around after a refresh. Thanks for taking a look, and I hope someone out there is willing to think about this crazy issue! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
pivot table grouping | Excel Discussion (Misc queries) | |||
Pivot table grouping | Excel Discussion (Misc queries) |