Microsoft Office Tutorials and References
In Depth Information
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 like. 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.
Tip You should find out whether your organization has an information retention policy that
would affect the amount of time you should keep your workbooks’ change histories.
The other important setting on this page deals with how Excel decides which of two
conflicting changes in a cell should be applied. For example, a service level’s price might
change, and two of your colleagues might type in what they think the new price should
be. Selecting the Ask Me Which Changes Win option enables you to decide whether to
keep the original price or the changed price.