pivot table on protected sheet

  • Thread starter Thread starter murats
  • Start date Start date
M

murats

hi,

The worksheet which I use to calculate some kind of working time ha
formula cells and they are protected. I want to create pivot tabe
using these cells but I couldn't because they are protected. Is ther
any way to do this ?

Thanks
 
You could use a macro to unprotect the worksheet, create the pivot
table, then reprotect the worksheet.
 
Back
Top