How-to

Ways to track changes in a shared Excel workbook

by XLTools team
March 30, 2016
3 min read
no comments

Companies that actively use Microsoft Excel for business analytics and reporting, often face the challenge of organizing group work on shared documents. In these cases issues like data safety and convenient versioning of a workbook are on top of the list. XLTools Version Control helps organize the process efficiently.

How to track changes in Excel workbooks

Working in Excel, one could accidentally enter wrong values or even erase valuable data. These unfortunate mistakes are familiar to everyone. This may lead to data corruption and put reliability of reports into question. When there are a few people collaborating on a same document, the risks increase. How could this problem be solved?

  • You can regularly save backup copies of workbooks:

    This leads to a pile of similar files “File_Final_1”, “File_Final_2”, “File_FinalFinal”, etc. It’s difficult to find the necessary documents, they consume disk space, and comparing two files is rather problematic.

  • You can activate Track Changes feature:

    This feature is frequently used in Word. The principle is the same: changes are registered for each cell, you can accept or decline them. But this feature does not have an option of recovering an earlier version of a workbook, so you still have to save backup copies, and the version log is stored for a limited time only.

  • You can purchase specialized software:

    Majority available solutions offer storing workbooks’ versions in a cloud. It requires training time to master the software, and the cost may exceed $1000 per year depending on number of users and subscription plan.

  • You can install XLTools Version Control and overcome these obstacles.

XLTools Version Control capabilities

With XLTools, you can organize workbook versioning directly in Excel interface. Most importantly, you will be sure that your data are safe.

XLTools Version Control: how to restore a previous version of a spreadsheet

  • Convenient both for individual and collaborative work,
  • Track who made the changes and when,
  • Compare any two versions and highlight changes,
  • Save versions as separate files whenever necessary,
  • Comment on versions,
  • Review and recover earlier versions,
  • All versions are stored in a git-repository and do not take much disk space,
  • XLTools does’t take long to learn and feels native to Excel,
  • All XLTools licenses are lifetime and include one year of free upgrades,
Also, we have recently released a long awaited update – to track changes in Excel VBA macros.
Tags:
Version control Excel add-ins
Any questions or comments?
jacob rodriguez Do you have something that can compare 2 xlsx or csv file and output the rows that have differences and show newly added rows into a 3rd file?
November 30, 2017 at 23:56
Maria Balobanova

Hello Jacob, you can try comparing Excel sheets (or CSV files opened in Excel) using the Compare tool within Workbook Organizer. The differences will be highlighted in red.

December 11, 2017 at 10:18
Related articles:
Forecast future dividends on shares of Russian companies [Free Excel Template] |  Excel Productivity Blog
Forecast future dividends on shares of Russian companies [Free Excel Template] | Excel Productivity Blog
December 22, 2020
10 min read
How to Remove Leading Spaces in Excel [Step-by-Step Guide] | Excel Productivity Blog
How to Remove Leading Spaces in Excel [Step-by-Step Guide] | Excel Productivity Blog
April 26, 2022
6 min read
Be the first to know