excel protection 2000

[[email protected]]

I want to protect a sheet and still use part of the file to do pivot
tables etc has anybody and suggestions

[Kevin B]

Put your pivot table on an unprotected sheet.
--
Kevin Backmann


"[email protected]" wrote:

> I want to protect a sheet and still use part of the file to do pivot
> tables etc has anybody and suggestions
>
>

[[email protected]]

Hi Kevin,

With Excel 2000 when you protect the data in a sheet the options for
pivot tables in the data menu is removed therefore you cannot add it to
another sheet.

Any other suggestions

Kevin B wrote:
> Put your pivot table on an unprotected sheet.
> --
> Kevin Backmann
>
>
> "[email protected]" wrote:
>
> > I want to protect a sheet and still use part of the file to do pivot
> > tables etc has anybody and suggestions
> >
> >