One way to prevent changes to an Excel workbook is by marking the workbook file as final. This sets the file to read-only and displays a yellow banner on top of the page letting the user know that this is the final version of the workbook and it shouldn’t be edited. That doesn’t mean they can’t edit it however. There is an Edit Anyway button that allows the user to make changes.
Once the Edit Anyway button is clicked, you will have to have to repeat the steps to set the file as final.
To Mark a Workbook as Final
- Click the File tab on the Ribbon and then click Info.
- Click the Protect Workbook icon in the center pane.
- Click Mark as Final from the list.
- Click OK to mark the file as final and then save it. The workbook then becomes read-only.
- To edit a workbook, open it and then click the Edit Anyway button on top of the screen.
Looking for more Excel tips? Check out our new book Excel 2016: Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks. Our Up to Speed guides are now available as downloadable PDF files, directly from this site as well.
Share this post