Quote:
Originally Posted by David
I'm working on a large spreadsheet which lets say is work in progress and
therefore I have to resave it each time it is updated under a different name
to distinguish between each saved copy.
Is it possible to set up the Excel file so whenever I go into it it creates
a new saved file with a dated reference, so I have a full audit trail (i.e.
historical log) in date order automatically.
--
David
|
I am the author of a product called TrackUment (
www.trackument.com) which solves the problem you have. After installing it, right click on your spreadsheet in Windows Explorer and select "TrackUment-Save Version" from the popup menu. Enter a comment and your version is saved.
You dont' have to create a copy of your spreadsheet each time it is updated, thereby saving you time and effort and keeping your folders uncluttered.
You can quickly get a list of previous versions of your spreadsheet, again, by just right clicking on the file and selecting an option from the popup menu.