How It Works
Relationship diagram
A Shared Workbook must have shared mode turned on. For unsaved workbooks, this will require a save, because revisions will be stored in the file.
Changes to the workbook are saved as Shared Workbook Revision Header parts within the document at each save or time interval specified.
A table summarizing the revision logs (revisionHeaders.xml) tracks when changes are made, who made them, and lists the relationship id to the specific Shared Workbook Revision Log part.
The application scans the summary table for new change logs and merges them into the workbook.