Microsoft Office Tutorials and References
In Depth Information
The items in the Inquire➜Diagram group each display a diagram:
➤ Workbook relationships
➤ Worksheet relationships
➤ Cell relationships
Figure 48-3 shows an example of worksheet relationships in a workbook that has four worksheets. It
shows that Sheet3 contains formulas that refer to Sheet1 and Sheet2, and Sheet4 has formulas that
refer to Sheet1.
Figure 48-3: This diagram depicts relationships between worksheets.
The Inquire➜Compare➜Compare Files command generates a detailed display that shows the
differences between two workbooks. Both of the workbooks to be compared must be open.
Figure 48-4 shows an example of the output.