No, you can't refresh the pivot table while the worksheet is protected.
You could record a macro to unprotect the worksheet, refresh the pivot
table, then protect the worksheet.

Sumanthkaka wrote:
Shall we refresh pivote table data in protected sheet


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com