Hello Chard,

This is one one of the downsides of using shared workbooks with Pivot tables. The format becomes fixed once the workbook is flagged to be shared. There is probably a reason for this, but I have no idea what it is.

Sincerely,
Leith Ross