I'm havinf trouble with a large pivot table that I've created. Everytime I alter the selections and change the the table, the format of certain cells/row/coloumns is changed.

Is there a way that I can lock the formatting down on a pivot table?

Thanks