Sorry it's not working
when i give a check Use Pivot table reports,we can select the data fom Page
in pivot table but i am unable get the refresh pivot table

"Sumanthkaka" wrote:

Shall we refresh pivote table data in protected sheet or shall we atleast
give a edit range (Tools--Protection--All users to Edit Ranges..)

Regards
Sumanth