| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Items in Report Filter of PivotTable not "checked" automatically
I have two pivottables connected to a master dataset. These PT (on separate
sheets) and dataset are in separate books. I have set different report filters but on common field for each PT. The 1st PT shows all items except blank and the 2nd PT shows only blank. My problem lies in 1st PT. Whenever master dataset changes, it reflects in PT but the updated field data is not automatically checked in report filter list and I have to manually select it to show updated data in PT. Please help me out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| How to keep "Header Row" button checked during Sort | Excel Discussion (Misc queries) | |||
| How do I move a document from "recent items" to "documents" | New Users to Excel | |||
| when a "check box" is checked, a "result" to be shown in another c | Excel Discussion (Misc queries) | |||
| Can I keep "Windows of active workbook check box" checked | Excel Discussion (Misc queries) | |||
Threaded Mode
