Changing Connections in Multiple-Grid Worksheets
To change the connection of a grid in a multiple-grid worksheet:
- In the grid whose connection you want to change, select a range of cells (You must select a range rather than only one cell).
- Using Excel Name Manager, delete the associated named range.
- From the Smart View Panel, right click the application to connect to, and then select Ad Hoc Analysis.