See links between worksheets

Important:  This feature isn’t available in Office on a Windows RT PC. Inquire is only available in the Office Professional Plus and Office 365 Professional Plus editions. Read Excel 2010 workbooks with Power Pivot don't work in some versions of Excel 2013. 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 Microsoft Office Professional Plus 2013 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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×