ExcelBanter - Protecting Pivot Tables.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protecting Pivot Tables. (https://www.excelbanter.com/excel-discussion-misc-queries/239049-protecting-pivot-tables.html)

GEM

Protecting Pivot Tables.

I have created a Pivot Table, and would like to protect it so no
modifications can be made. I only want for people to select the place at the
very top, the PAGE area.

Is this possible??

Max

Protecting Pivot Tables.

One thought is to simply kill the pivot(s) via paste specialvalues.
That way, there would be no doubt about it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"GEM" wrote:
I have created a Pivot Table, and would like to protect it so no
modifications can be made. I only want for people to select the place at the
very top, the PAGE area.

Is this possible??

GEM

Protecting Pivot Tables.

But how would you be able to use the PAGE section if there is no Pivot Table?

"Max" wrote:

One thought is to simply kill the pivot(s) via paste specialvalues.
That way, there would be no doubt about it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"GEM" wrote:
I have created a Pivot Table, and would like to protect it so no
modifications can be made. I only want for people to select the place at the
very top, the PAGE area.

Is this possible??

All times are GMT +1. The time now is 02:29 AM.