If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Protecting pivot tables
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?
|
#2
|
|||
|
|||
Protecting pivot tables
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? |
Thread Tools | |
Display Modes | |
|
|