Results 1 to 5 of 5

Thread: Locking down a pivot table

  1. #1

    Locking down a pivot table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am working on a stopgap report using Excel in which I would like to down a pivot table (ie not allow changes to filters or data selected) and would like to have it distributed so that business users could add comments in the column to the right of the pivot table. Is there a way to lock the pivot table without locking down the excel workbook?

    Any help would be greatly appreciated.

    Thanks,

    Sean

  2. #2
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    Would it work for you to COPY-PASTE VALUES into a new spreadsheet and then share that?

  3. #3
    That's a good workaround - trying to eliminate as many 'manual' steps as possible.

  4. #4
    You could lock down the pivot table cells, including the filters, via Protect Sheet. Select the cells you want "untouchable" and lock them down. This will leave the column for comments accessible.

  5. #5
    Quote Originally Posted by Gwen View Post
    You could lock down the pivot table cells, including the filters, via Protect Sheet. Select the cells you want "untouchable" and lock them down. This will leave the column for comments accessible.
    Perfect - Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •