I have a pivot table linked to an Access table which works fine.
I am about to let other people use the pivot table so that they can view the
data any way they choose.

Does anyone know of a way to restore the pivot table back to it's 'original'
view?

Obviously you could exit the worksheet and not save it but I want the user
to be able to keep it open.

Thanks for helping.