How to Prevent Others from Changing Your Excel File by Marking it as the Final Version

Excel can also be in different version. And today, we will talk about marking the file as the final version to protect your Excel.

When you send your Excel file to other people, you will certainly want to tell him or her that this file is the final version. Instead of telling them directly, you can also mark the file as the final version. Therefore, they can know immediately from this form. And the following are the steps about marking the file.

Mark the Final Version

  1. Click “File” in the ribbon.
  2. And then click the button “Protect Workbook”.
  3. In the drop-down menu, click the option “Mark as Final”.Mark as Final
  4. Next you will see a dialog that reminds you of the operation. Thus, click “OK” in the window.Click OK
  5. And then another window will also pop up. It says that your document is in the final version. So here still click “OK”.Click OK Again

Thus, your workbook is in the read-only mode. And then if you send it to other people, they will see the prompt bar in the interface.

Prompt Bar

If you need to modify the file again, you may unmark the final version. And there are 2 methods to unmark the target file.

Unmark the Final Version (Method 1)

  1. Click “File” in the ribbon.
  2. And then click “Protect Workbook”.
  3. In the drop-down menu, click the option “Mark as Final”.Unmark

Here you click the button, so the file will be in the ordinary version. Thus, you can also edit in the workbook.

Unmark the Final Version (Method 2)

You will see the notification message in the interface of the worksheet of a marked file. Here click the button “Edit Anyway”. Thus, the workbook will not be in the mode of read-only. And you can now edit again.Edit Anyway

If you forget to save the workbook even if you do no modification after clicking the “Edit Anyway”, the file will still be marked as final. Therefore, don’t forget to save it before you close the file.

Recovering Corrupt Excel Files from an Accidental Situation

If your work depends much on Excel, you will have a great possibility to meet with an accidental situation. Once you suffer from one, your data and formation will hard to survive. In such situation, you will certainly try to recover Excel as soon as possible. With the strengthening of technology, we have already developed a sophisticated tool to recover Excel. It is now the best recover tool for Excel around the world. And with the perfect algorithm, it can solve almost all the problems of Excel perfectly.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.