B
barbara
Hi all,
I have a spreadsheet that includes confidential revenue
info on it which I cannot transmit electronically. This
sheet is the basis for a series of pivot tables that
represent the revenue range by color and in aggregation
which is OK to send. To keep recipients from viewing the
revenue info, I can hide the columns and password-protect
the base sheet. However, it is then still possible to
access the information by pulling the revenue fields in
via the pivot table wizard. Is there a way to prevent
recipients from adding new fields to a pivot table or is
there another way to protect this information?
Thanks in advance,
Barbara
I have a spreadsheet that includes confidential revenue
info on it which I cannot transmit electronically. This
sheet is the basis for a series of pivot tables that
represent the revenue range by color and in aggregation
which is OK to send. To keep recipients from viewing the
revenue info, I can hide the columns and password-protect
the base sheet. However, it is then still possible to
access the information by pulling the revenue fields in
via the pivot table wizard. Is there a way to prevent
recipients from adding new fields to a pivot table or is
there another way to protect this information?
Thanks in advance,
Barbara