Excel Guideline #10: Keep Version Management Clear and Consistent
Creating good spreadsheets is an art. We write articles about creating good reliable spreadsheets every other week. Never miss one!
Guideline 10: Keep Version Management Clear and Consistent
What version did I receive from you? Oh, I have modified the previous version. Has the board made a decision based on that version?... Many nightmare has arisen because of confusion about the correct versions of Excel files. In the file itself, it is often difficult to see what the latest version is. And is the latest version the right version, or was it a “temporary break” to try something?
Read our guideline in which we advise to use a clear system with version numbers, like software programmers do.
On perfectxl.com you can Subscribe on our guidelines for free.
Jerts Consulting & Services
7 年The article provides good advice that, in my experience, works well in practice. A structured approach to version numbering makes a lot sense. When I implemented this approach in my business, I found it tedious to manually change the version numbers (and sometimes I forgot to do it) so I wrote a bit of code to automate the process - one procedure to add a decimal to the version number (e.g. v1.1 to v1.1.1), one to remove a decimal (e.g. v1.1.1 to v1.2) and another to just increase the version number (e.g. v1.1 to v1.2 or v1.1.1 to v1.1.2). Buttons on my Quick Access Toolbar linked to the code makes changing the version numbers and saving the file a one-click process. Mateo Mol you need to fix the typo in the title - change Managent to Mangement.