Managing ConnectionsCData Excel Add-In for Office 365 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 Office 365 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.