Author Topic: Protecting an excel workbook  (Read 1138 times)

Protecting an excel workbook
« 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?
We are making a New World (Paul Nash, 1918)

Re: Protecting an excel workbook
« Reply #1 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

Phil W

Re: Protecting an excel workbook
« Reply #2 on: 06 August, 2019, 12:44:16 pm »
Why not make everyone elses access to the spreadsheet, read only in Sharepoint?

vorsprung

  • Opposites Attract
    • Audaxing
Re: Protecting an excel workbook
« Reply #3 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


Re: Protecting an excel workbook
« Reply #4 on: 10 August, 2019, 11:01:12 am »
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:
We are making a New World (Paul Nash, 1918)