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: