But....I need the Pivot table to have a fixed format (which I can do with 'Preserve cell formatting on update') and to have all of the rows and columns in irrespective of whether there is data or not (i.e. if I have not sold any apples in June, I still want the 'Apples' field to appear, just with a value of zero).