Important: Spreadsheet Inquire is available only in Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions. Want to see what version of Office you're using?
A great way to check for links between worksheets is by using the Worksheet Relationship command in Excel. You can use this command, found on the Inquire tab, to quickly build a diagram that shows how worksheets are linked to each other. If you don't see the Inquire tab in the Excel ribbon, see Turn on the Spreadsheet Inquire add-in.
-
Open the file that you want to analyze for worksheet links.
-
On the Inquire tab, select Worksheet Relationship.
The Worksheet Relationship Diagram appears, showing links between the worksheets in the workbook.
See alsoÂ
Compare workbooks using Spreadsheet Inquire
Compare two versions of a workbook by using Spreadsheet Compare
Analyze a workbook with Spreadsheet Inquire
See links between workbooks​​​​​​​
Clean excess cell formatting on a worksheet
Manage passwords used to open files for analysis and comparison
