software

I need to ask few question on pivot table:

First is when i make file workbook protected and hide master sheet on which
table is based, file gets corrupted...
Secondly, can i hide pivot functions and toolbars for users. Like when user
uses Pivot table, he can know what are the fields in source, formatting
changes etc, Can i disables these functions and allow users only drill down
or options select or filtering functions.. Please adviceHi Sandy

Firstly, hiding the sheet upon which the Pivot Table is based before
saving shouldn't corrupt your file. There must be some other reason.
For information on disabling PT features take a look at
www.contextures.com/xlPivot12.html

--
Regards

Roger Govierquot;Sandyquot; gt; wrote in message
...
gt;I need to ask few question on pivot table:
gt;
gt; First is when i make file workbook protected and hide master sheet on
gt; which
gt; table is based, file gets corrupted...
gt; Secondly, can i hide pivot functions and toolbars for users. Like when
gt; user
gt; uses Pivot table, he can know what are the fields in source,
gt; formatting
gt; changes etc, Can i disables these functions and allow users only drill
gt; down
gt; or options select or filtering functions.. Please advice
gt;
Sir Have tried it again. In this there were 2 sheets, One where data was
present and other report. I hided the data sheet and then passowrd protected
workbook:
When i send the file to other user, and user opened it up (we both are using
same excel 2003) it gave following error:

quot; Errors were detected in quot;test.xlsquot; but microsoft office excel was able to
open the file by making repairs listed below.Save the file to make these
repairs permanently.quot;
PivotTable Report quot;Pivot Tablequot; on '[test.xls]Sheet2' was discarded due to
integrity problems.quot;

This way I cant hide source data from users which is very critical for me. I
have seen this on many occassions and hence i only hide source sheet without
password.
quot;Roger Govierquot; wrote:

gt; Hi Sandy
gt;
gt; Firstly, hiding the sheet upon which the Pivot Table is based before
gt; saving shouldn't corrupt your file. There must be some other reason.
gt; For information on disabling PT features take a look at
gt; www.contextures.com/xlPivot12.html
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Sandyquot; gt; wrote in message
gt; ...
gt; gt;I need to ask few question on pivot table:
gt; gt;
gt; gt; First is when i make file workbook protected and hide master sheet on
gt; gt; which
gt; gt; table is based, file gets corrupted...
gt; gt; Secondly, can i hide pivot functions and toolbars for users. Like when
gt; gt; user
gt; gt; uses Pivot table, he can know what are the fields in source,
gt; gt; formatting
gt; gt; changes etc, Can i disables these functions and allow users only drill
gt; gt; down
gt; gt; or options select or filtering functions.. Please advice
gt; gt;
gt;
gt;
gt;

Also Sir, am referring codes for restricting pivot table but its not
functioning. Please help. Even after providing codes, i can do formatting,
remove add fields, etc. Toolbars are usable.

quot;Roger Govierquot; wrote:

gt; Hi Sandy
gt;
gt; Firstly, hiding the sheet upon which the Pivot Table is based before
gt; saving shouldn't corrupt your file. There must be some other reason.
gt; For information on disabling PT features take a look at
gt; www.contextures.com/xlPivot12.html
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Sandyquot; gt; wrote in message
gt; ...
gt; gt;I need to ask few question on pivot table:
gt; gt;
gt; gt; First is when i make file workbook protected and hide master sheet on
gt; gt; which
gt; gt; table is based, file gets corrupted...
gt; gt; Secondly, can i hide pivot functions and toolbars for users. Like when
gt; gt; user
gt; gt; uses Pivot table, he can know what are the fields in source,
gt; gt; formatting
gt; gt; changes etc, Can i disables these functions and allow users only drill
gt; gt; down
gt; gt; or options select or filtering functions.. Please advice
gt; gt;
gt;
gt;
gt;

Hi Sandy

Just to test that what I had said was correct, I created a 2 page file.I
set up a small set of data on page 1.
I created a PT, allowing it to create the table on a new page. I deleted
all pages other than the original with data, and the sheet containing
the PT. I hid the data page, then protected the workbook and saved the
file.
I sent the file by email, to another computer within our building.
I opened the file on the second computer, no problems.When trying to
unhide the other sheet, the option was greyed out because of the
Workbook protection.
The Pivot table can be used to select or deselect items from view, but
no drill down is possible as it cannot access the source sheet.
The ability to control this selection ability can be modified following
the link I gave you previously.

I am using XL2003. The recipient machine is running XL2002 (but I don't
think that is an issue).
Try it again with a brand new simple test file as I did and see what
happens. If that works, then the problem must be with your original PT
and /or data file. If it doesn't work then I'm afraid I have no other
ideas as to why it doesn't work for you.

--
Regards

Roger Govierquot;Sandyquot; gt; wrote in message
...
gt; Sir Have tried it again. In this there were 2 sheets, One where data
gt; was
gt; present and other report. I hided the data sheet and then passowrd
gt; protected
gt; workbook:
gt; When i send the file to other user, and user opened it up (we both are
gt; using
gt; same excel 2003) it gave following error:
gt;
gt; quot; Errors were detected in quot;test.xlsquot; but microsoft office excel was
gt; able to
gt; open the file by making repairs listed below.Save the file to make
gt; these
gt; repairs permanently.quot;
gt; PivotTable Report quot;Pivot Tablequot; on '[test.xls]Sheet2' was discarded
gt; due to
gt; integrity problems.quot;
gt;
gt; This way I cant hide source data from users which is very critical for
gt; me. I
gt; have seen this on many occassions and hence i only hide source sheet
gt; without
gt; password.
gt;
gt;
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Sandy
gt;gt;
gt;gt; Firstly, hiding the sheet upon which the Pivot Table is based before
gt;gt; saving shouldn't corrupt your file. There must be some other reason.
gt;gt; For information on disabling PT features take a look at
gt;gt; www.contextures.com/xlPivot12.html
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Sandyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I need to ask few question on pivot table:
gt;gt; gt;
gt;gt; gt; First is when i make file workbook protected and hide master sheet
gt;gt; gt; on
gt;gt; gt; which
gt;gt; gt; table is based, file gets corrupted...
gt;gt; gt; Secondly, can i hide pivot functions and toolbars for users. Like
gt;gt; gt; when
gt;gt; gt; user
gt;gt; gt; uses Pivot table, he can know what are the fields in source,
gt;gt; gt; formatting
gt;gt; gt; changes etc, Can i disables these functions and allow users only
gt;gt; gt; drill
gt;gt; gt; down
gt;gt; gt; or options select or filtering functions.. Please advice
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;