how does tracking changes relate to sharing a workbook in excel?

Tracking changes in Excel is directly related to sharing a workbook because the Track Changes feature only works in shared workbooks. When you enable tracking changes, Excel automatically shares the workbook, allowing multiple users to edit it simultaneously while keeping a record of every change made. This record shows who made what edits and when, which helps maintain accountability, transparency, and version control over the collaborative work. In essence, sharing a workbook enables real-time collaboration among multiple users, and tracking changes enhances this by highlighting edits, listing changes in a separate sheet if desired, and allowing acceptance or rejection of modifications. However, this sharing and tracking functionality comes with limitations, such as some Excel features being disabled in shared mode and potential conflicts if multiple users edit the same cells concurrently. Newer Excel versions support co-authoring instead of shared workbooks, which has different implications for tracking changes. Thus, tracking changes and sharing a workbook are complementary features that together facilitate effective and controlled collaboration on Excel files.