Microsoft Office Tutorials and References
In Depth Information
Sharing workbooks
IMPORTANT You can’t share a workbook that contains an Excel table. To share the
workbook, convert the Excel table to a regular cell range by clicking the Excel table, clicking the
Design tab and then, in the Tools group, clicking Convert To Range. Click Yes in the dialog box
that opens to confirm the change.
On the Advanced page of the Share Workbook dialog box, two settings are of particular
interest. The first determines whether Excel should maintain a history of changes made to the
workbook and, if so, for how many days it should keep the history. The default setting is for
the program to retain a record of all changes made in the past 30 days, but you can enter
any number of days you want. If you revisit your workbook on a regular basis, maintaining
a list of all changes for the past 180 days might not be unreasonable. For a workbook that
changes less frequently, a history reaching back 365 days (one year) could meet your
tracking and auditing needs. Excel deletes the record of any changes made earlier than the time
you set.
Search JabSto ::

Custom Search