Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table refresh
I have a workbook with 134 pivot tables all liked to the same access table
(excel and access 2007), when I refresh the pivottable1, all table refresh as they are all linked to the same data source. The problems arise after refesh, all 133 pivot tables that were created by copy and paste of the original pivot table change field settings to those of the original pivot (in my case there are three age/sex/marital). As an exapmle, pivot 1 age = 18, sex = male, marital = single, pivot 2 age = 20, sex = male, marital = single, pivot 3 age = 22, sex = male, marital = single etc. After refresh they all say age = 18, sex = male, marital = single. So i decided to write a macro to change the fields to what I need them to be after refresh, the problem gets even stanger, if I run the marco prior to refresh, no problems, but when I run it after refresh, it gives a procudure error, it does not recognze the page command. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Pivot Table Refresh | Excel Discussion (Misc queries) | |||
Pivot Table Refresh | Excel Worksheet Functions | |||
Pivot Table refresh | Excel Discussion (Misc queries) | |||
Pivot table refresh | Excel Discussion (Misc queries) |