Quote:
Originally Posted by H-B
Before I have used version control in Excel, so I could rool back to a
previous version of the file. It seems only to be possible in Word now, can
that be right? I want to use that function, instead of saving a file in
several versions, e.g. file1, file2 and so on.
|
As far as I know, Excel does not have a version control feature like Word.
Saving a copy of your spreadsheet each time you make a change can be tedious. There is another post in this forum that contains code you can add to a worksheet that automatically creates a copy of the spreadsheet each time it is saved. But you still have to deal with multiple files for each version.
Or, you can check out a product I wrote called TrackUment (
www.trackument.com) that solves the problem you have. To save a version with TrackUment, just right click on the spreadsheet in Windows Explorer and select "TrackUment-Save Version" from the popup menu, enter a comment and you're done.
Looking up through all your spreadsheet versions and extracting any of them, is easily done, by just right-clicking on the file and selecting "TrackUment-Show History" from the popup menu.
Try the free trial version of TrackUment at
http://www.trackument.com/download.html and see if it helps solve your problem.