Ok what I've done is simply go 2 steps back via the wizard to a new set of
data- usually a transposed sheet of original data.

Sometimes I need to add new flelds to the data, sometimes not.

I use Deborah's fantastic pivot table addin to reset all data fields to 'Sum
of' & procede from there.

No code, just a few easy , repetitive steps.
Cheers now, Rob.