Thread: Update data but keep pivot table formatting

I created a pivot table from a worksheet using the pivot table wizard. During Step2 of the process I extended the range beyond the rows I had. Once the wizard was finished I selected the pivot table, then using the downward arrows by the pivot table headers I hid the blanks. After that I formatted the table with fonts and colors.

After I collected new data I returned to the workbook and deleted the old data from the worksheet that the pivot table was linked to and in its place I pasted the new data. The only thing I didn’t replace from the source data worksheet was the headers. After the new data was entered I returned to the pivot table, right clicked on it, and selected refresh data.

The pivot table data was accurate but the formatting that I had added to the pivot table disappeared.

Is it possible to modify the pivot table settings so that when I refresh data, although the data will change, the formatting (colors, fonts,etc) will remain the same?

Why are you working like this? A Dynamic Named Range is ideal for data source for PivotTables- the range expands as data is added.