Tuesday, May 24, 2022

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 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 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

No comments:

Post a Comment