Managing ConnectionsCData Excel Add-In for OData 2019 - Build 19.0.7354
Connection profiles can be per-user settings tied to your Windows account, or you can embed connections in the workbook for easier sharing. The permissions associated with your connection profile also control the allowed operations.
To change the connection linked to a worksheet, click From OData from the CData ribbon, which allows you to do the following:
- Click Edit to modify the connection parameters.
- In the Connection menu, select another existing connection.
- In the Connection menu, select the option to create a new connection.