Disable refresh on pivot table

[laurenpeta]

Hi all,

Looking for some help with a pivot table please - I have enabled editing of the values using vba so that users can overwrite the value, however using slicers (important for my purposes) resets the value to the original.

Is there code to disable the pivot table from refreshing values at all? So that I can filter the data with slicers without losing the changes. I also want to protect the pivot table from being accidentally refreshed and losing the updated values.

I've tried various vba -

.ManualUpdate = true
.Calculation = xlCalculationManual
ActiveSheet.EnableCalculation = False

But they don't seem to have any affect.

thanks team

[Parth007]

What if you protect the sheet? it will not allow the code to do anything if its protected.