Pivot Tables

Hi Kayleigh

Thank you for your question

I would suggest writing the code that formats your pivot table in a separate procedure. You can then call this after the pivot table is created. You could also then call it after your pivot table is refreshed and this would add back in any missing formats.

The following code will refresh an existing pivot table

ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh