Changing Connections in Multiple-Grid Worksheets

To change the connection of a grid in a multiple-grid worksheet:

1. In the grid whose connection you want to change, select a range of cells (You must select a range rather than only one cell).
2. Using Excel Name Manager, delete the associated named range.
3. From the Smart View Panel, right click the application to connect to, and then select Ad Hoc Analysis.