Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016 Microsoft 365 admin

Important: This feature isn’t available in Office on a Windows RT PC. Inquire is only available in the Office Professional Plus and Microsoft 365 Apps for enterprise 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. If Office Professional Plus is installed on your computer, 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.

  1. Open the file that you want to analyze for worksheet links.

  2. On the Inquire tab, click Worksheet Relationship.

Worksheet Relationship command

The Worksheet Relationship Diagram appears, showing links between the worksheets in the workbook.

Worksheet Relationship Diagram

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.