Put your pivot table on an unprotected sheet.
--
Kevin Backmann


" wrote:

I want to protect a sheet and still use part of the file to do pivot
tables etc has anybody and suggestions