Protected sheet Pivot Table Refresh & formula Update

priyankalad

New Member
Joined
Jul 1, 2015
Messages
1
Hi,
I have three columns in my data that is been calculated automatically using the 'IF' formula. I am making Pivot Tables from this data and refreshing it using VB codes when the worksheet is activated. But as soon as I am protecting my sheet, the pivot table is not been refreshed and the formula as well is not being updated. I used the VB codes to Unprotect the sheet & to refresh the table & to protect it again. It is working but the issue now is with the formula that is not being updated. What could I do to make the pivot table refresh & the formula to update at the same time when the sheet is being protected?

Thanks.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,460
Members
414,069
Latest member
StudExcel

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
Top