Yet Another Cycling Forum

General Category => The Knowledge => Ctrl-Alt-Del => Topic started by: rafletcher on 06 August, 2019, 11:07:51 am

Title: Protecting an excel workbook
Post by: rafletcher on 06 August, 2019, 11:07:51 am

I want to upload a spreadsheet to a sharepoint site so it's readily viewable, but not editable. It's a multi-sheet document.  The only way I can see to do it is to individually protect each sheet using the "protect sheet" tab with a password, and selecting the various attributes to protect. The "protect workbook" option only offers "protect structure" and I'm unclear as to what this means.

And yes, I know I can do this as a pdf, but what are the options in Excel?

Title: Re: Protecting an excel workbook
Post by: Si S on 06 August, 2019, 12:35:37 pm

Protect structure protects the sheets so they can't be hidden, copied, deleted etc. You already know what protect sheet does.

Sounds like you want to protect both the sheets and the workbook

Title: Re: Protecting an excel workbook
Post by: Phil W on 06 August, 2019, 12:44:16 pm

Why not make everyone elses access to the spreadsheet, read only in Sharepoint?

Title: Re: Protecting an excel workbook
Post by: vorsprung on 06 August, 2019, 04:23:53 pm

you don't need to protect it in Excel

you need to ensure that it cannot be replaced on the sharepoint thing, except by you

Title: Re: Protecting an excel workbook
Post by: rafletcher on 10 August, 2019, 11:01:12 am

Quote from: vorsprung on 06 August, 2019, 04:23:53 pm

you don't need to protect it in Excel

you need to ensure that it cannot be replaced on the sharepoint thing, except by you

Which I can do by checking it out I think  :thumbsup: