Hello,
We are using a named range so our pivot tables can cope with new rows but is there any way to create a pivot table that uses named ranges for each column so that inserted columns etc don't break the pivot table? Our data sheets are already named like that (one large named range then named ranged per column)...
The motivation behind this is that our users are allowed to add their own columns to the underlying data and we would really like to stick with Excel for the analysis.
Many thanks
Sam
Bookmarks