Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table page fields add values previously deslected
I have pivot tables that I have selected only certain data in a page
field by dragging it to the detail, selecting only what I want, then dragging it back to the page section. The problem is that when new data shows up in the file, it automatically adds that data to the field. This can cause erroneous information to be reported. Is there any way to stop it from doing this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to eliminate xero values from pivot table and list top 10 only | Excel Worksheet Functions | |||
flattening aggregated fields in pivot table | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
Manipulating Pivot Table Data Fields | Charts and Charting in Excel | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) |