search

NetOfficeFw / NetOffice

🌌 Create add-ins and automation code for Microsoft Office applications.
MIT License
697 stars 143 forks source link

Defer Layout Update #259

Open aganur-ahundov opened 4 years ago

aganur-ahundov commented 4 years ago

[Question]

Hello!

How to get Defer Layout Update flag from the framework? If the flag is checked I have an exception while pivotTable.Update() invoking.

How I can check if the flag checked to prevent updating the table??

jozefizso commented 4 years ago

There is a property PivotTable.ManualUpdate which should defer layout update, but I tested it in Excel 365 and the property does not match the Defer Layout Update value in the actual pivot table.

https://docs.microsoft.com/en-us/office/vba/api/excel.pivottable.manualupdate

https://stackoverflow.com/questions/32486195/defer-layout-update-of-pivottable