Disclaimer: I have a workbook with protected health information in it (reason why workbook is not attached). Also, I have little experience with workbook and worksheet events.
Problem: I have a customer complaining that every time they manipulate a pivottable in the workbook, that the workbook starts calculating, which takes a long time and freezes the users Excel until calculations are finished.
My Thinking on a Solution: My thinking is to use a workbook level event like SheetPivotTableChangeSync to control how extensive the calculations are and reduce calculation time and reduce the end user's computer resource consumption.
Request: Can anyone offer up any good advice with example code? If it helps for me to share the workbook, can you suggest the best way for me to clear out the protected patient health information and insert dummy (fake) values that are not related to any real patient?
Many Thanks,
-Kyle
Problem: I have a customer complaining that every time they manipulate a pivottable in the workbook, that the workbook starts calculating, which takes a long time and freezes the users Excel until calculations are finished.
My Thinking on a Solution: My thinking is to use a workbook level event like SheetPivotTableChangeSync to control how extensive the calculations are and reduce calculation time and reduce the end user's computer resource consumption.
Request: Can anyone offer up any good advice with example code? If it helps for me to share the workbook, can you suggest the best way for me to clear out the protected patient health information and insert dummy (fake) values that are not related to any real patient?
Many Thanks,
-Kyle