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