Thanks, that did the trick. I am also having problems with getting rows with
no data to collapse. Any ideas?

"Roger Govier" wrote:

Hi

Try right click on PTTable Optionsde-select Autoformatselect Preserve
Formatting

--
Regards
Roger Govier



"Jarod" wrote in message
...
I am having a problem with formatting the cells in a pivot table. Every
time
I format the cells, and then change the number in the drop down box, the
formatting goes back to the way it was. How do I fix this?