Excel should be able to track changes without sharing workbook
 

Several of the users I support have asked for the functionality to track
changes on a Workbook without sharing the Workbook.

While I could probably write some VBA to achieve this they are looking for
the same functionality that comes with shared workbooks with sharing. They of
wish to add sheets or delete and insert cells which cannot be done in a
shared workbook.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc