Home

I am unable to grant access to users to refresh a pivot table in a protected worksheet :(

%3CLINGO-SUB%20id%3D%22lingo-sub-338361%22%20slang%3D%22en-US%22%3EI%20am%20unable%20to%20grant%20access%20to%20users%20to%20refresh%20a%20pivot%20table%20in%20a%20protected%20worksheet%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338361%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20stuck%20and%20would%20need%20some%20help%20from%20you%20guys.%20I%20started%20off%20by%20doing%20CTRL%2BA%20on%20the%20same%20worksheet%20that%20I%20intend%20of%20having%20it%20protected%2C%20and%20did%20a%20CTRL%2B1%20to%20format%20cells%20and%20unticked%20the%20'Locked'%20option.%20After%20having%20unlocked%20all%20cells%2C%20I%20proceeded%20with%20highlighting%20the%20range%20I%20wanted%20to%20protect%2C%20CTRL%2B1%20again%20and%20selected%20both%20locked%20and%20hidden%20this%20time%20round!%20I%2C%20then%20protected%20the%20worksheet%2C%20setting%20up%20a%20password%2C%20and%20granting%20the%20users%20all%20access%2C%20bar%20formatting%20cells%2C%20and%20deletion%20of%20rows%20(which%20shouldn't%20affect%20a%20pivot%20table%20I%20think).%20After%20reentering%20the%20password%20of%20protection%20the%20refresh%20option%20of%20the%20pivot-table%20quickly%20became%20ghosted.%20I%20don't%20know%20why%2C%20but%20I%20granted%20user%20access%20to%20make%20use%20of%20the%20pivot%20table%2C%20as%20well%20as%20auto-filter%2C%20edit%20scenarios%20etc.%20Why%20is%20this%3F%20What%20am%20I%20doing%20wrong%3F%20Can%20you%20please%20help%20me%20out%20in%20this%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-338361%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
stefmiff_-1120
New Contributor

Hi, I am stuck and would need some help from you guys. I started off by doing CTRL+A on the same worksheet that I intend of having it protected, and did a CTRL+1 to format cells and unticked the 'Locked' option. After having unlocked all cells, I proceeded with highlighting the range I wanted to protect, CTRL+1 again and selected both locked and hidden this time round! I, then protected the worksheet, setting up a password, and granting the users all access, bar formatting cells, and deletion of rows (which shouldn't affect a pivot table I think). After reentering the password of protection the refresh option of the pivot-table quickly became ghosted. I don't know why, but I granted user access to make use of the pivot table, as well as auto-filter, edit scenarios etc. Why is this? What am I doing wrong? Can you please help me out in this? Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies