# How to Update Your Spreadsheet's Molecule Credentials

If you need to update a spreadsheet connected to Molecule's API with new credentials, follow the instructions below.

#### Method 1

The easiest method is to update an existing spreadsheet after your Molecule password, or API token has been changed.

Open your spreadsheet and click **Refresh All** on the **Data** tab:

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/7519bob1ji/1689265006191/file-wd-ye-84-dje.png" alt=""><figcaption></figcaption></figure>

Upon being prompted for new credentials, select **Basic** in the sidebar navigation, enter your email address and Molecule API token, then click **Connect**.  If you need help generating a Molecule API token, follow the instructions [here](https://help.molecule.io/integrations-and-apis/integrations-guide/getting-started-with-molecule-api/how-to-generate-an-api-token) or [here](https://developer.molecule.io/docs/authentication):

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/7519bob1ji/1689265006466/file-0-o-2-tcajg-pj.png" alt=""><figcaption></figcaption></figure>

#### Method 2

This method describes how to edit the credentials connected to Molecule's API via spreadsheet.

Open your spreadsheet and navigate to the **Data** tab. Choose **Get Data** > **Data Source Settings:**

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/7519bob1ji/1689265006689/file-p-8-t-ood-5-u-ps.png" alt="" width="375"><figcaption></figcaption></figure>

On the resulting popup, select the **Global permissions** radio button and click **Edit Permissions:**

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/7519bob1ji/1689265007021/file-n-djxr-ohmv.png" alt="" width="563"><figcaption></figcaption></figure>

On the resulting popup, select **Edit:**

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/7519bob1ji/1689265007325/file-qimc-jut-rrm.png" alt="" width="563"><figcaption></figcaption></figure>

On the resulting popup, make sure that **Basic** is selected in the sidebar navigation. enter your email address and Molecule API token, and click **Save**.  Click **OK** / **Close** through the open windows to complete saving the new credentials:

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/7519bob1ji/1689265007559/file-g-qb-tetjr-2-h.png" alt="" width="563"><figcaption></figcaption></figure>
