Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table drop downs not refreshing
Several months back I had located a macro script to put into my Excel program
that when run, it would refresh the pivot table drop down boxed with current data (which it wasn't doing before even after removing and readding that field into the pivot table). Unfortunately , that macro was lost in the transition to a new computer and I'm wondering if anyone knows what that script is. Thanks for any help you can give me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table drop downs not refreshing
This should help you.
http://www.contextures.com/xlpivot04.html -- HTH, Barb Reinhardt "kerncollies" wrote: Several months back I had located a macro script to put into my Excel program that when run, it would refresh the pivot table drop down boxed with current data (which it wasn't doing before even after removing and readding that field into the pivot table). Unfortunately , that macro was lost in the transition to a new computer and I'm wondering if anyone knows what that script is. Thanks for any help you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Drop Downs | Excel Discussion (Misc queries) | |||
Pivot Table Drop Downs | Excel Discussion (Misc queries) | |||
Pivot table drop downs | Excel Discussion (Misc queries) | |||
reading into pivot table drop downs | Excel Discussion (Misc queries) | |||
Can Pivot table drop-downs act like AutoFilter | Excel Discussion (Misc queries) |