If I add a new column to existing named table data source (Table1) and refresh pivot data, any pivot table associated with that table resets, as in removes all the row, columns and filters etc.
The same thing occurs when I remove column that is no longer require, even if that column is not used anywhere in the pivot table.
Is there a way to preserve the pivot table layout without then having to recreate it and any conditional formatting if associated with it?
Am I better off using an area name and using 'offset' to get the length as opposed to using a simple table?
Thank you
The same thing occurs when I remove column that is no longer require, even if that column is not used anywhere in the pivot table.
Is there a way to preserve the pivot table layout without then having to recreate it and any conditional formatting if associated with it?
Am I better off using an area name and using 'offset' to get the length as opposed to using a simple table?
Thank you