Protecting pivot tables

[Emma Wood2012]

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

 

[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
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.