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

 
 
Applies to:
Excel 2013, Office 365 Enterprise, Office 365 Enterprise admin, Office 365 Midsize Business, Office 365 Midsize Business admin