Title:
Faster Pivot Table Macros with Manual Update
Video:
Description:www.contextures.com 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
Published:
07/Mar/2011
Faster Pivot Table Macros with Manual Update
Video:
Description:www.contextures.com 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
Published:
07/Mar/2011
No comments:
Post a Comment