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?
Bookmarks