Open navigation

How to manage shared and private connections in Excel

Shared and private connections are available to teams that use Supermetrics with Excel.


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 Team Site.


Manage all connections

You can open the Team Site from the Supermetrics sidebar to manage your connections. This gives you an overview of all your connections and their sharing settings.

  1. Open the Supermetrics add-in.
  2. Navigate to the Data source list in the sidebar. 
  3. In the top right, click Manage
View connections
  1. Open the Supermetrics sidebar.
  2. Navigate to the Data source list.
  3. You’ll find your connections under Connected data sources.
  4. Click the caret iconnext to the data source’s name to open it. If you have more than 1 connection for the data source, you’ll see a list.
    My connections → Connections that you’ve created. You can keep them private, or share them with your team.
    Shared with you → Connections that belong to other team members and have been shared with you.
Share connections

To create a new shared connection:

  1. Open the Supermetrics add-in.
  2. Navigate to the Data source list in the sidebar.  
  3. If the data source already has a connection, expand the list under Connected data sources.
  4. Click Add connection.


To share an existing connection:

  1. Open the Supermetrics add-in.
  2. Navigate to the Data source list in the sidebar.
  3. Under Connected data sources, you’ll see a list of your connections. 
  4. Click the Share icon. This will give team members access to this connection.
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. 


You can also use the steps below to solve an error that reads The connection used in this query is no longer shared.


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

  1. Open the Supermetrics add-in.
  2. Navigate to the same data source as the one used in the unshared connection. Click Add connection
  3. In the top right, click Manage to open the Team Site.
  4. Click the 3-dot menu next to the unshared connection.
  5. Click Replace connection.
  6. Select the new connection you created in Step 1, and confirm your choice.


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

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.