I use pivot tables in my spreadsheet.

When I protect the sheets to prevent changes to locked cells, the pivot
tables wont allow data refresh?!

Even when I check all the boxes when protecting a sheet - including the
pivot tables check box, still the pivot tables cannot be activated.

The pivot table cells are all unlocked as is the data it reads from.

Can anyone help me?

Tahnks,

Roger