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

Protecting an excel workbook
« on: August 06, 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: August 06, 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

Re: Protecting an excel workbook
« Reply #2 on: August 06, 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: August 06, 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

Audaxing Blog follow @vorsprungbike on

Re: Protecting an excel workbook
« Reply #4 on: August 10, 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)