Hello, Do someone know how to do it in VBA (like in GUI) - To start to defer update, make all fields changes, and at the end only apply all updates at once.
- PivotTable property 'ManualUpdate' : dont work for OLAP-PivotTable as it does for Standard-PivotTable
- And by default OLAP PivotCache update at each field change. Which can be quite slow, when you want to apply several field-changes at the same time
We're stilll using EXCEL-2016 at my Office. But test it also with EXCEL-2021 = same behavior.
- PivotTable property 'ManualUpdate' : dont work for OLAP-PivotTable as it does for Standard-PivotTable
- And by default OLAP PivotCache update at each field change. Which can be quite slow, when you want to apply several field-changes at the same time
We're stilll using EXCEL-2016 at my Office. But test it also with EXCEL-2021 = same behavior.