Thread: [Solved] Excel 2010 Pivot Table Qs
View Single Post
 
Old 09-19-2011, 05:27 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
You need to remove the lock flag from the Pivot Table Header cells.
The select Tools -> Protection and make sure the flag for "Use Pivot Table Reports" is ticked. Then click OK.
This will lock all data cells and only allow the user to change the filters.
Good luck.
Tony(OTPM)
Reply With Quote