[Emma Wood2012]

Not sure if this is already a question, but I have a spreadsheet with
115 sheets and they contain pivot tables and charts. I need to give
viewing access to this document, but I do not want anyone to be able to
drag fields or view any other drop down information. This is a template
and so I want to update it every month. Other than protecting all
sheets (very time consuming) and then unprotecting and maybe recording
this as a macro (again time consuming) I do not know what else to try
and I refuse to believe there is not a simple solution. Can anyone
help?




--
Emma Wood2012

[Jay Freedman]

You might get a better answer in an Excel group -- this one is for Word --
but I think the best answer is to keep your workbook unprotected and
undistributed, and publish it as a PDF file each month.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Emma Wood2012 wrote:
Not sure if this is already a question, but I have a spreadsheet with
115 sheets and they contain pivot tables and charts. I need to give
viewing access to this document, but I do not want anyone to be able
to drag fields or view any other drop down information. This is a
template and so I want to update it every month. Other than
protecting all sheets (very time consuming) and then unprotecting and
maybe recording this as a macro (again time consuming) I do not know
what else to try and I refuse to believe there is not a simple
solution. Can anyone help?