Stop Pivottable Changes From Starting Lengthy Workbook Calculations

kyle_bos

New Member
Joined
Aug 30, 2017
Messages
4
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
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,223,239
Messages
6,170,947
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top