With the way pivot tables are going now with slicers and timelines and the like I think there is more expectation that they'll be used in models.
Using them in VBA is still a ballache though.
I’ve cheated in the past and used normal cells to mirror the pivot. Not sure how efficient with 90m lines though!
@aggi started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
With the way pivot tables are going now with slicers and timelines and the like I think there is more expectation that they'll be used in models.
Using them in VBA is still a ballache though.