Let’s assume that you are making an annual performance report for your business. For obvious reasons, you want to show it to only top management or those who have the clearance. At such a moment, it is recommended to use a password so that others cannot view it even if they get access to the file. On the other hand, let’s say that you want to send a file that should not be visible after a particular time. To specify that date, you can set an expiration date.
How to set Expiration Date when sharing Excel files online
To set an expiration date when sharing Excel files online, follow these steps: To learn more about these steps, continue reading. To get started, you need to open Excel Online on your browser and open the file you want to share with others. After opening the file, you can find a Share button on the top-right corner. You need to click on this button.
Then, you can find a pop-up window on your screen. Here you need to click on the Anyone with the link can edit option.
After that, click on the Set expiration date option and set a date as per your requirements.
At last, click the Apply button. After that, whenever you share the file with others, it will expire after the specified date. The only disadvantage of this functionality is that you cannot set a time. In other words, your file will get expired at 11:59 PM on the specified date.
How to set Password when sharing Excel files online
To set a password when sharing Excel files online, follow these steps: Let’s delve into these steps in detail. At first, you need to open the spreadsheet in Excel Online and click on the Share button visible on the top-right corner. Following that, click on the Anyone with the link can edit option visible on the popup menu. Following that, click the Set password option and enter a password you like. It is always recommended to set a strong password.
Once done, click the Apply button to save the change. After that, whenever you will share the spreadsheet with anybody, he/she will require a password to open the file.
How do I set the expiry date in Excel?
To set the expiry date in Excel, you need to use Excel Online. It is possible to set an expiration date for your spreadsheet so that people cannot open it after a predefined date. For that, you need to click on the Set expiration date option and enter an expiry date you like.
Can you password protect OneDrive Excel?
Yes, you can password protect OneDrive Excel files. If you do not want to share the file, you can put it in the Personal Vault. However, if you want to share files with a password, you need to click on the Set password option. Then, you can enter your desired password. That’s all! I hope, this guide helped you. Read: Microsoft Excel Online tips and tricks to help you get started.
