• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Protecting a Worksheet but allowing Users to use Pivot Table Filters

T

tom_m

New Member
Hi,

I have developed a dashboard in Excel 2003.


The front sheet contains 7 x pivot tables (data hidden) with a series of adjacent formulas calculating KPI % achievements.


I wish to lock down the worksheet and protect all formulas, hidden rows etc. However, I wish for all users to be able to use all 7 x pivot filters.


When I protect the sheets (not locking cells where the pivot table appears), I get an error message stating that Pivot tables are not able to be used when the sheet is locked.


Does anyone have a workaround?


Thanks,


Tom
 
You must log in or register to reply here.
Back
Top