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.
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.