Shared workbooks in SpreadsheetML allow for real-time concurrent multi-user editing of a workbook. Changes are tracked through a revision log that records edit details and maintains a revision history. The application scans the log for new changes and incorporates them into the workbook in real-time, enabling a collaborative "track changes" feature for multiple users.