I used Sheet1 as the data source to create a pivot table in a new worksheet
which I named PT Sheet. Using Excel 2003, I took the following steps to do
it

- Created the pivot table with the pivot table wizard.
- In Step 2 of the wizard I expanded the range of the rows well beyond what
I
needed to pivot the data I had.
- Once the pivot table was created I clicked the downward arrows on the
pivot
table and de-selected (blank) so the blank rows of data were hidden.
- Next I added formatting to the pivot table, i.e. colors, fonts, etc.
- After I collected new data I returned to Sheet1, (the data source for the
pivot
table), deleted the old data, and pasted in the new data; I did not touch
the
header columns.
- Next I returned to PT Sheet, (the worksheet containing the pivot table),
right
clicked on it, and selected Refresh data.
- The data was refreshed and accurate but the formatting was gone.

Does anyone know what I can do to the pivot table so that when I Refresh
Data, the formatting that I added to it manually will not disappear?