posalite.blogg.se

Provide a password and choose all the fields that you want to restrict others from editing and hit “ Ok” Now go to Review section –> Click on “ Protect Workbook” option If you have multiple sheets, these steps must be repeated for each one. To do this, open the desired workbook from your Excel desktop application and click on the required sheet which will be your current sheet in the setting we are going to set. This means, others will not be able to amend the data or change structure within a workbook but still can open and see it. However, it won’t help if your requirement is to restrict the viewing of the file, but we can restrict changes from others. It simply means you need to key in a password to open the Excel file.Īs this is currently unsupported in Office 365 Excel online, let’s find out an alternative to restrict at least certain functions of an Excel Workbook. This level of encryption is usually done within the Excel application using the Protect Workbook feature. Specially as Microsoft stated in the article above, if you have Excel files with password protected, they won’t open in excel online and you will get the message below. Go through this article carefully to understand the full list of limitations – Some organizations intend to downgrade their Office 365 E3/E5 plans to E1 due to economical aspects but there are some serious consequences which could impact the business. There are some limitations on excel web app compare to desktop app.

If you are one of those users who heavily rely on excel desktop application and thinking of moving fully cloud, perhaps you must think twice.