Share via

Remove "Refresh Data" option on Pivot table context menu - HELP

Anonymous
2010-08-23T14:34:44+00:00

Hello all and thanks in advance.

I am trying to perform a very easy function and I just cannot seem to get this accomplished. I need to remove the ability for a user to refresh a pivot table by right-clicking the pivot and selectined "Refresh Data". I have looked online and can't find an example of my problem (could be serching incorrectly). Please advise if there is a simple way to do this for Excel 2003.

Regards.

Me.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-08-23T15:05:09+00:00

Hi, did you check the box that says use pivot table reports , is where it says 'Allow users of this worksheet to , is under where you enter the password in the dialog box

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-08-23T18:41:47+00:00

    Ediardp,

    Thanks for the quick notice. I followed the directions and now I'm set. I didn't see that option before. Thanks the for the help!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-08-23T14:58:19+00:00

    Hi ediardp,

    I found this method on another post, but when i protect the sheet, I cannot dynamically change the pivot layout. Am I doing something wrong? This pivot functionality is a requirement of the report and limits the user.

    Please advise,

    Warm Regards,

    Me.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-08-23T14:47:44+00:00

    Hi,Protect the sheet , when protecting it check the box Use pivot table reports in order to allow them to filter the Pivot table

    Was this answer helpful?

    0 comments