When a user tries to open the workbook, they will be prompted to enter the password. A dialog box appears prompting you to re-enter the password.īelow is the dialog box that prompts for a password:Ĭlose and save the workbook.
Be sure to keep your password in a safe place. To prevent other users from opening a workbook by encrypting a password: Preventing other users from opening a workbook Choose the desired option from the menu.īelow are the options to protect a workbook:
Click Protect Workbook or Encrypt with Password and then Protect Workbook. Open the Excel workbook you want to protect with a password. You can use password protection to add security and prevent other users from opening a workbook, changing a worksheet or worksheets or altering workbook structure. The easiest option is to use the File tab in the Ribbon. If you want to prevent users from accessing or changing a workbook, password protection can be added to your Excel file in a number of ways. You can lock and protect an Excel workbook by adding a password using your security options. I also realize that I could use Excel's password protection feature on spreadsheet, but I thought file encryption is more secure.Lock and Protect Your Excel Worksheets and Workbooksīy Avantix Learning Team | Updated May 31, 2021Īpplies to: Microsoft Excel 2010, 2013, 2016, 2019 and 365 (Windows) I realize that before downloading the file from the server to the client, Windows 10 has to decrypt the file, and that is what is taking very long when opening the file on a network client.īefore the 1809 update when using BOTH file encryption and a password protected file, it opened fast. So the problem is not network or the desktop server speed. Also, opening the file on the Desktop which shares the file, it opens very fast. When I disable the File Encryption on the file on the server, the file loads fast. download it from a desktop server share to the networkĬlient). It takes way too long (25seconds) to open the 200Kb spreadsheet (ie. 
I have some files where I use the Windows 10 file properties>encryption (not Bitlocker) on a spreadsheets.
0 kommentar(er)
