Pivot Table and sheet Protection problem
Posted by Nona Sloven on May 02, 2001 7:50 AM
I have a pivot table in Excel97. I wonder if there is a way to protect the sheet where I have put my pivot table to reside. When I choose Tools|Protection|Protect Sheet
, the dropdown lists on my table stops to work. They cant be opened, and when you hover the mouse cursor over any of them the cursor changes its appearance unto a hand. The reason I need this sheet protection is because some cells I have added with formulas in range B6:C8. I´ll apreciate any help on this. Thank you.