Versioning and Change Control in Excel. What are the popular ways oftracking versions and/or changes

  • Thread starter Thread starter rebelx
  • Start date Start date
Status
Not open for further replies.
R

rebelx

I suppose this is really two separate questions really. Just curious
what are the methods employed by the users of this group for
spreadsheet versioning, and also what are the methods employed to
track changes within a spreadsheet.

I know that 2003 had a version tracker as well as "Track Changes"
functions, but they were rather hopeless in deployment.

Are there any add-ins or other type of development software that
people here have used that work well?

I've looked at various software packages, but most are very expensive
and require hardware and use of a network or communal type server. I
was hoping there was something easier and less expensive to use.
Anybody here run into anything that fits this bill?
 
Not an answer to your query but where in Excel 2003 do you find a version
tracker function?

Something I've been missing? Highly likely<g>


Gord Dibben MS Excel MVP
 
Actually, I was confused. There's a "Versions" menu item under File in
Word. I thought it was in Excel too, but after a second look, looks
like its not there. Sorry.
 
That will share the workbook and track changes made but I don't see where it
would track versioning.


Gord
 
TrackUment is a software tool that solves your problem of spreadsheet versioning. It does not require any technical knowledge or special hardware to setup or use.

After installing it, right click on your spreadsheet in Windows Explorer and select "TrackUment->Save Version" from the pop up menu. Enter a comment in the window that opens up and click the "Save" button. That's all you have to do.

You can also see a list of versions for your spreadsheet and retrieve any version at any time.

To download the free trial visit www.trackument.com.

Rajeev

Disclaimer: I am the author of TrackUment.
 
Answering your first question, Excel does not have an inbuilt version control feature like Word 2003. In fact this feature has been removed from Word 2007 and 2010 as well. For version control with multiple users, the only options are to go for expensive software or use open source software like SVN.

If as a single user you want to keep a history of changes you make to your spreadsheets, then you can try an add-in for Excel 2007 called RevisionLog that I created recently. Every time you make changes and save your spreadsheet, RevisionLog will save the changes as a revision. You can add and edit comments to any revision, so that you can keep a record/history of changes you have made. RevisionLog is single user only and is more of a personal productivity tool.

You can download the free trial at http://www.revisionlog.com/

Rajeev

PS: I am the one who posted as "Rajeev Kumar" above. I forgot my password and tried retrieving it from the password recovery link. But it kept saying that the image verification failed, even though I entered the text in the image exactly. Hence I created this new userid to make this post.
 
Status
Not open for further replies.
Back
Top