TOLL FREE: 1 855 TRUE SKY (878 3759)

Blog

Read up for news, tips and tricks about budgeting, planning and forecasting.

Accounting Excel Tips

Final Version of an Excel Workbook

So you’ve worked long and hard to complete an Excel workbook. You have gathered input from multiple sources, incorporated changes from high-level management and finally, you have arrived at the final version. Hooray!

But wait! Someone in your company missed the deadline on their changes and decided to access the workbook to do the unforgivable… (Insert evil music) change the final version, Duh Duh Duhhh! Hours of meticulously consolidating the workbook and trying to maintain version are now wasted and you must start over to incorporate the new information that has been lumped in.

There are many Excel tips, and one handy tip can help you avoid this process : the Mark as Final command.

Mark as Final Command

Use the Mark as Final command in excel to ensure a shared Excel workbook has no further changes made to it. This prevents reviewers from editing the document by communicating that a shared version is being sent.

Marking a file as final saves the document as read-only and disables typing, editing and proofing marks, while setting the status property of the document to “Final”.

You can practice this exercise with any Excel protect workbook. Applies to:  Microsoft® Excel® 2010 and Microsoft Excel 2013.

1. Open your workbook and click the File tab,

excel protect workbook

 

Then select Info:

Excel Protect Workbook

2. Under Permissions, click Protect Workbook,

Excel Protect Workbook

 

 

 

 

 

 

Then select Mark as Final:

 

Excel Protect Workbook

 

Notes:

  • The Mark as Final status can be removed from the file
  • Files that have been marked as final in a Microsoft® Excel® program are not read-only if someone opens it in an earlier version of Microsoft® Exc el®