In pivot Table shall we assign a cell to allow user to edit range
S Shane Devenshire Jul 8, 2009 #2 Hi, Please elaborate on this question - what do you mean by assign a cell? What do you mean by edit a range? You can edit a pivot table to some extent.
Hi, Please elaborate on this question - what do you mean by assign a cell? What do you mean by edit a range? You can edit a pivot table to some extent.
S Sumanthkaka Jul 9, 2009 #3 I have a pivot table beside that I created a formula based table which is need to be in protection if I protect the sheet I am unable to refresh the pivot data Is there any way to get refresh in protected sheet?
I have a pivot table beside that I created a formula based table which is need to be in protection if I protect the sheet I am unable to refresh the pivot data Is there any way to get refresh in protected sheet?
