Hi, I'm trying to set up a template that contains a formatted pivot table
(e.g. presents sums that are formatted as dates). It looks fine, but the
problem I'm getting is that the field across the top is "holding on" to
values that no longer exist in the source table. I tried removing the field,
saving the file, and then putting it back in, but it seems to make no
difference. I don't want to recreate the table from scratch because I'll
lose all the formatting, but I don't want to confuse users with options on
the field list that aren't there.

Any suggestions on how to reset this?

Thanks,
Geoff.