Consider the following guidelines when using sheet information.

• You can see separate Connection sections in the Sheet Info dialog box for each valid grid present on the sheet. For example, Connection (Grid 1), Connection (Grid 2), and so on.
• In a multiple-grid sheet, if all the grids are connected to the same connection, then you can view their details such as Server, Application, URL, Provider, Alias Table, and Associated Range in their respective Connection section.
• In a multiple-grid sheet, if any of the grids are connected to a different connection than the one from which the Sheet Info dialog box is launched, you can see only the following limited details in the Connection section:
  • Associated Range: Name of the cell ranges associated with the grid
  • Information: Message indicating "The grid is associated with a different connection".

  For example, you are working on a sheet with Grid 1 and Grid 2 connected to Planning and Grid 3 connected to Tax Reporting. If you launch the Sheet Info dialog box using the Sheet Info option on the Smart View ribbon for Tax Reporting, you can see full details for Grid 3, including server, application, URL, provider and so on. However, for Grid 1 and 2, you only see the associated range name and an informational message stating "The grid is associated with a different connection". To view the sheet information for Grid 1 and 2, use the Sheet Info option on the Smart View ribbon for Planning.

• In a multiple-grid sheet, if you rename a grid range or delete its original name using Excel's Name Manager, instead of Smart View's Rename Grid Range option, then Smart View considers such a grid as invalid. This is because the grid's connection is broken, thus preventing Smart View from identifying it. You cannot view details of such a grid in the Sheet Info dialog box and cannot perform any grid operations on such a grid.

  It is recommended to always use Smart View's Rename Grid Range option for giving friendly or understandable names to your grids. For more information, see Renaming Grid Ranges.

• For a Function sheet, the Sheet Info dialog box only displays the Sheet Type as Function. No other description is available for display for a Function sheet.