Refresh Pivot table data in protect sheet
Hi,
To allow refresh of a pivot table in a protected sheet protect the sheet by
choosing Tools, Protection, Protect Sheet, and check Use Pivot Table Reports.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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
|