---
title: "How to manage shared and private connections in Excel"
slug: "how-to-manage-shared-and-private-connections-in-excel"
description: "Manage Supermetrics Excel connections easily—share with your team or keep them private. Learn to create, replace, and manage data source connections."
updated: 2026-05-20T08:47:09Z
published: 2026-05-20T08:47:09Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to manage shared and private connections in Excel

The Supermetrics Excel add-in lets you share data source connections with your team, or use private connections. Your private connections will work in any Supermetrics destination you use. Please note that private connections won't work in data warehouse destinations.

Shared connections will enable all members of your team to build reports using these connections in any Supermetrics destination.

Follow these instructions to manage your shared and private connections in Excel. Learn also how to [manage the shared and private connections on the Supermetrics Hub](/v1/docs/how-to-view-and-manage-access-to-private-and-shared-connections).

****View connections****

1. Open the Supermetrics add-in.
2. Click **Create new query** and navigate to the **Data source**list in the sidebar. You can also click the menu icon in the top-left corner and select **Manage data source connections**.
3. You'll find the connections available to you under **Connected data sources**.
4. Click the chevron****next to the data source's name to open it. If you have more than 1 connection for the data source, your connections are grouped into two categories:
  - **My connections** → Connections that you've created. You can keep them private, or share them with your team.
  - **Shared with me** → Connections that belong to other team members and have been shared with you.

****Add new connection****

1. Open the Supermetrics add-in.
2. Click **Create new query** and navigate to the **Data source**list in the sidebar. You can also click the menu icon in the top-left corner and select **Manage data source connections**.
3. Enter the data source name in the search field. If the data source has a connection, click the chevron next to the data source name to expand the list of available connections.
4. Click **Add connection**.
5. Keep the sharing option turned on and connect to the data source.
6. Click **Start**.

****Share connections****

To create a new shared connection:

1. Open the Supermetrics add-in.
2. Click **Create new query** and navigate to the **Data source**list in the sidebar. You can also click the menu icon in the top-left corner and select **Manage data source connections**.
3. Enter the data source name in the search field. If the data source has a connection, click the chevron next to the data source name to expand the list of available connections.
4. Click **Add connection**.
5. Keep the sharing option turned on and connect to the data source.
6. Click **Start**.

To share an existing connection:

1. Open the Supermetrics add-in.
2. Click **Create new query** and navigate to the **Data source**list in the sidebar. You can also click the menu icon in the top-left corner and select **Manage data source connections**.
3. Enter the data source name in the search field. If the data source has a connection, click the chevron next to the data source name to expand the list of available connections.
4. Click the **Share icon**. This will give team members access to this connection. ![Supermetrics interface showing data source connection options and sharing settings.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/excel-share-connection.png)

****Replace a connection****

If you've lost access to a connection used in one of your queries — for example, if the user who added it has left your organization — you can replace it. This means that all queries using this connection will start using the new one. Please note that this action can't be canceled without contacting our support team.

You can replace a connection only if you have more than one connection to the data source. If you need to replace a connection, add a new connection first.

Note that only users with the Admin or Owner role can replace connections.

1. Open the Supermetrics add-in.
2. Click **Create new query** and navigate to the **Data source** list in the sidebar.
3. In the top right corner, click **Manage**to open the Hub.
4. On the Hub, navigate to the data source with the connection to be replaced, and click the data source to expand its details.
5. Find the connection you need to replace and click **Replace connection**.
6. Select a new connection, and confirm your choice.

Any queries that used the unshared connection will now use the new connection instead.

****Manage all connections****

You can open the Hub from the Supermetrics sidebar to manage all your connections. This gives you an overview of all your connections, their sharing settings, and [depending on your team role, extended connection management options](/v1/docs/about-shared-and-private-connections).

1. Open the Supermetrics add-in.
2. Click **Create new query** and navigate to the **Data source** list in the sidebar.
3. In the top right corner, click **Manage**.

[Learn how to manage shared and private connections on the Supermetrics Hub](/v1/docs/how-to-view-and-manage-access-to-private-and-shared-connections).