Pivot - can i lock the design

P

Peter

Hi guys,

I have i pivot table with some autocalculations and formatted cells added.
Is there a way in which i can "lock" the pivot view so that everybody can
viwe it but without being able to delete columns, change captions, etc.?
 
M

Maurice

I assume you have created a pivot using a crosstabquery. In that case anyone
can view the table and not edit it because the recordset will not be
updatable anyhow (or read only for that matter). So you don't have to do
anything special...

hth
 
P

Peter

May be i did not express myself quite clearly the first time. Actually i
created the Pivot Table using the standard pivot wizard and it appeared in
the forms list of the database window. When opened in PivotTable view it
shows several rows and several columns (not surprisingly :)). Unfortunately
everybody can select a row and delete it from pivot view and the next time
the table is opend in pivot view the previously deleted column is absent - i
must prevent this at any cost. can you help
 
M

Maurice

Peter,

Sorry for the misunderstanding. Two questions:

1. Which version are you using?
2. How did you create the pivot from the wizard (Where did you start?)
 
P

Peter

1) Version: Access 2003 (11.5614.5606)

2) New Forms -> Pivot Table Wizard (i also chose the table where the data
comes from) -> Next -> "Which fields would you like to include in your Pvot
Table object?" (chose the fields) -> Finish.
 
Top