Faster Pivot Table Macros with Simple Code Change

Excel macros can run slowly on a large pivot table, or one with calculated fields or calculated items. By adding a line of code to your macro, you can make the code run faster, because automatic updating is turned off. The line of code shown in this video is: pt.ManualUpdate = True Find more pivot table refresh tips and macros on my Contextures site: https://www.contextures.com/excelpivottablerefresh.html