version control of dcoments in excel

  • Thread starter Thread starter angela
  • Start date Start date
A

angela

Hello

Word has a version control feature built in.
How do you do that in excel?

Right now we manually increase version numbers by renaming the file :
abc_v11.xsl, abc_v12.xls
The reason this is bad is that we also want to put links to the latest
version in other documents.I it will be nice if it worked like word where
the latest version is the original file name and it never changes.
Therefore, the links always point to the latest version.

Any help will be appreciated.

thanks

Sergio
 
At the end of the day, Save the file, so all the changes are kept.
Then, choose File>Save As
Add the date to the end of the file name, e.g.:
ABC20041002.xls
Save it in a "Versions" file.

The next morning, open the original file, and continue your work.
 
Should be: Save it in a "Versions" FOLDER

Debra said:
At the end of the day, Save the file, so all the changes are kept.
Then, choose File>Save As
Add the date to the end of the file name, e.g.:
ABC20041002.xls
Save it in a "Versions" file.

The next morning, open the original file, and continue your work.
Click to expand...
 
I guess I do understand. However, I was looking for automatic version
control.
If I understood you method, it requires saving the original document
ABC.xls, then "save as" in a version folder at the end of the day.

The problem with your approach is that many people update the file during
the day. So we may go through 5 revisions in one day. Also, like I said ,
we have links to this document from other sources. Our procedure includes
now bumping the version number when we do a save as and then saving this
lateast version to another file called "ABC_latest.xls". This is the file
that is linked in other documents.

So you are telling me that there is no way to do automatic version control
without the user renaming files.

thanks

Sergio
 
If multiple people update your spreadsheets and you want to save each update as a revision, then you can look into using version control software like CVS, Git, SVN etc. These are free software and can help you keep track of changes to your spreadsheet. But they also require some expertise in installation, setup and use. You can also checkout www.trackument.com for an easy to use version control software.
 
Back
Top