On Aug 27, 10:31*am, Mr CheeZe
wrote:
I have created a pivot table where i need to change the data frequently and
sum up the total minutes per week of an activity.
i am using a 'week number' format and using'getpivotdata' to populate
another part of the spreadsheet.
the problem occurs when there is no data for a particular week and the pivot
table refresh deletes the week 'column' entirely therefore destroying my
'getpivotdata' format on the other page.

example

first set of pivot data;
week no; * 31 * * *32 * * 33 * * *34 * * * 35
mins * * * 165 * * 25 * *180 * * 134 * * *145

second set of pivot data;
week no; * 31 * * *32 * * 34 * * *35 * * * * 37
mins * * * *120 * * 36 * * 208 * * 356 * * * 38
.................................................. .........
desired scenario for second set of data;
week no; * 31 * * *32 * * 33 * * *34 * * *35 * * 36 * *37
mins * * * *120 * * 36 * * *0 * * * 208 * * 356 * * 0 * *38 *

how can i preserve the 'missing' weeks in my pivot table?
a zero is acceptable in the minutes row.

many thanks for your help

Mr CheeZe

In your second set of pivot data you need to show week no. 33 and the
mins of 0. If you are refreshing a pivot table, there has to be data
in order for it to populate.