Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. When changes are made in the shared workbook, you can view the change history directly on the sheet or on a separate history sheet. Either way, you can instantly review the details of each change.
These techniques will work with XLOOKUP, Index Match, or any other formula where you want to bring in data from a separate workbook. 3. In the shared workbook, on the Review tab, in the Changes group, click Share Workbook.