Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Controlling Workbook Distribution
The Sales Reports document library is now set up to support versioning. Whenever a workbook is saved
to the library, a version is created. A major version is created for every new workbook. A minor version
is created implicitly on every subsequent save. The workbook author has control over whether a major
or minor version is created when he or she explicitly checks it in.
You can also set up the document library to require authors to check out workbooks before they can
edit them. This ensures that if multiple people are working on the same workbook, no conflicts occur. If
someone tries to edit a workbook while it is being edited by someone else (and is therefore checked out),
that person receives an error message and cannot access the workbook.
In the following Try It Out, you work with major and minor versions of the sample Sales Report and view
the version history of the workbook.
Try It Out Working with Versions
To work with different workbook versions, follow these steps:
If you previously uploaded sales report.xlsx to the Sales Reports document library, delete the file
from the document library by selecting Delete from the drop-down menu next to the filename.