Versioning Your Work in Progress


When you're collaborating on a spreadsheet, it helps to keep different versions of the file on hand as you work; this lets you return to a previous version, if necessary.

Google Spreadsheets doesn't offer automatic versioning. In fact, as Google saves your changes as you make them, it's a little tricky to move backward through the different iterations of your work. However, there is a trick you can employ to add versioning to your spreadsheets. Here's how it works:

1.

When you're ready to create a new version, select File, Save As.

2.

When prompted, save the current file with a version after the name. For example, if the file is named spreadsheet1, you might save the current version as spreadsheet1v01 or spreadsheet1v02. You might even want to save the date as part of the filename, as in spreadsheet1 7-1-06v01.

3.

Any time you make a major change to the spreadsheet, repeat steps 1 and 2 and give the file a new version name.

Some users version their work once a day; others do it once an hour; still others do it whenever they add or change anything big in the spreadsheet. How often you save new versions is up to you, but the important thing is to save your work in multiple iterations. This will make it relatively easy to recover a previous version, if necessary.




Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net