ExcelBanter - EXCEL PROTECTION 2000

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

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

- - EXCEL PROTECTION 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/96028-excel-protection-2000-a.html)

[email protected]

EXCEL PROTECTION 2000

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

Kevin B

EXCEL PROTECTION 2000

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

" 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]

EXCEL PROTECTION 2000

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

" wrote:

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

All times are GMT +1. The time now is 07:23 PM.