MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
I have a worksheet which contains two pivot tables, I want to protect this sheet, so that the pivot tables still update on refresh
I have tried 'unlocking' the columns which contain the pivots, then protecting the sheet but this does not seem to work
Am I doing something wrong?
TIA
I have tried 'unlocking' the columns which contain the pivots, then protecting the sheet but this does not seem to work
Am I doing something wrong?
TIA