R
Richard Ward
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.
(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.