In the modern workplace, important decisions are often made based on information derived from spreadsheets. Whether it’s finalizing an annual budget or building a financial model to examine a possible investment, the spreadsheet plays a pivotal role due to its unquestionable usefulness and endless business applications. Naturally, best practice dictates that proper file management is necessary to ensure the integrity of the spreadsheets and the data they contain. A single file can change hands many times among departments, teams, and colleagues over time. When the stakes are high regarding important business decisions, and with industry specific regulations looming in the background, doesn’t it make sense to maintain a complete and accurate file history that captures key information about each specific version? We think so.

Version Control is a multifaceted approach to tracking a file and its modifications, copies, renames, over time. Ideally, you would want to identify each unique iteration and pull information on what was done to the file, who did it, and when the update occurred. Version Control doesn’t have to be a hassle, if you are working with the right tools. To simplify this process, Apparity applies a ‘fingerprint’ to the file and automatically tracks every future version. The file history is then displayed in a convenient format within Excel. By implementing Version Control, organizations will:

· Make better-informed decisions from reliable data

· Identify a file’s origin and track its evolution over time

· Increase accountability and file integrity

· Compare multiple versions

· Revert the file to a previous version if necessary

· Easily provide a detailed file history to managers and auditors

If you would like to learn more about safeguarding your spreadsheets with Version Control, please contact the Apparity Team to learn more about our free resources and services.