Selecting an Alias Table for the Connection

You can select an alias table for private connections only. If you want to select an alias table for a shared connection, first save the shared connection as a private connection. See Saving Connections as Private Connections.

An alias table selected for a private connection is permanent until changed and will be used each time you use this connection. Setting an alias table for your private connection may help prevent the "Member out of place " error that appears after refreshing an ad hoc sheet which has data copied from other sheet using Microsoft Office copy and paste commands.

To select an alias table for the connection:

1. From a worksheet, connect to a data source using a shared connection and then save it as a private connection. For more information, see Saving Connections as Private Connections.
2. Connect to the private connection you created in the previous step.
3. Right-click the connection name and select Set Alias Table.
   You can also select the connection, click More in the Action panel, and select Set Alias Table.
4. Select an alias table for the connection.

   The new alias table is applied the next time you open the connection.