> For the complete documentation index, see [llms.txt](https://www.bluegamma.io/documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.bluegamma.io/documentation/integrations/excel-add-in/troubleshooting.md).

# Troubleshooting

Solutions for common issues when installing or using the BlueGamma Excel Add-in.

Having trouble with the BlueGamma Excel Add-in? This page covers the most common issues and how to resolve them.

***

## "Not available in selected billing region"

**What it means:** Microsoft AppSource is blocking the download because your Microsoft 365 account is tagged to a region where the add-in isn't recognised as available.

This isn't about your credit card billing country — it's based on your Microsoft 365 **usage location** setting.

**How to fix it:**

1. **Contact your IT team** and ask them to check:
   * Your Microsoft 365 **usage location** is set correctly (e.g., United Kingdom, Germany, United States)
   * You have the same **Office/Store permissions** as colleagues who can install the add-in
   * Your **Microsoft 365 licence** includes access to AppSource add-ins
2. **If you're an admin**, check the user's usage location in the Microsoft 365 admin centre:
   * Go to **Users** → **Active users**
   * Select the affected user
   * Check **Licenses and apps** → **Location**

The BlueGamma add-in is published globally, so this issue is typically caused by account permissions or usage location settings on your organisation's side.

***

## "Add-in failed to download required resource"

**What it means:** Your corporate network or firewall is blocking the connection to BlueGamma's servers.

**How to fix it:**

Ask your IT team to **allowlist the following domains**:

| Domain                                  | Purpose                                                      |
| --------------------------------------- | ------------------------------------------------------------ |
| `*.bluegamma.io`                        | BlueGamma API and add-in resources                           |
| `api.bluegamma.io`                      | API endpoints for data retrieval                             |
| `auth.bluegamma.io`                     | Authentication services                                      |
| `excel.bluegamma.io`                    | Add-in task pane, custom functions and icons loaded by Excel |
| `app.bluegamma.io`                      | Sign-in flow for the add-in                                  |
| `*.execute-api.eu-west-2.amazonaws.com` | Data requests from the add-in's custom functions             |

**Additional checks:**

1. **Test connectivity** by opening <https://api.bluegamma.io> in your browser
   * If you see a response, the connection works
   * If it's blocked, you'll see a timeout or security warning
2. **Check proxy settings**: some corporate proxies block specific domains
3. **Try a different network** — if the add-in works on a personal network but not your corporate network, this confirms a firewall issue

Once your IT team allows access to these domains, the add-in should work normally.

***

## "Add-In not in plan"

**What it means:** Your BlueGamma account doesn't include Excel Add-in access, or your account hasn't been activated yet.

**How to fix it:**

If you're signed in to the add-in without access, the task pane offers a 2-week free trial: click the chat icon in the task pane to request it. Otherwise:

1. **Check your subscription** — log in to [app.bluegamma.io](https://app.bluegamma.io) and verify your plan includes Excel Add-in access
2. **Contact support** — email <support@bluegamma.io> to:
   * Activate Excel Add-in access on your account
   * Upgrade your plan if needed
   * Start a trial if you're evaluating BlueGamma

***

## Add-in not appearing in Excel

**What it means:** The add-in may not be installed correctly, or Excel hasn't loaded it.

**How to fix it:**

1. **Check the Home tab**: look for the **BlueGamma** button on the **Home** tab of the Excel ribbon
2. **Manually load the add-in:**
   * Go to **Insert** → **Get Add-ins** (or **Office Add-ins**)
   * Search for "BlueGamma"
   * Click **Add**
3. **Clear the Office cache:**
   * Close Excel completely
   * Delete the contents of: `%LOCALAPPDATA%\Microsoft\Office\16.0\Wef\`
   * Restart Excel
4. **Reinstall the add-in:**
   * Remove the add-in from **Insert** → **Get Add-ins** → **My Add-ins**
   * Reinstall from [Microsoft AppSource](https://appsource.microsoft.com/en-us/product/office/WA200007779)

***

## Functions returning errors

| Error     | Cause                                                   | Solution                                                                                                                                                                     |
| --------- | ------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `#VALUE!` | The request failed                                      | Hover over the cell's error indicator to see why, for example a date in the wrong format (use YYYY-MM-DD or Excel dates), an unknown index name, or "Please re-authenticate" |
| `#NAME?`  | Function not recognised: Excel hasn't loaded the add-in | Open the add-in from **Home** → **BlueGamma**. If the button is missing, see [Add-in not appearing in Excel](#add-in-not-appearing-in-excel)                                 |
| `#BUSY!`  | Still loading                                           | Wait a few seconds for the data to load                                                                                                                                      |

**If errors persist:**

1. Click the **BlueGamma** button on the **Home** tab and check the status in the task pane: it should show **Add-in Enabled**
2. Try signing out and signing back in
3. Check your internet connection

***

## Values not updating

BlueGamma formulas recalculate when their inputs change. They don't re-fetch market data on their own. Two controls in the task pane decide when you get fresh values:

* **Refresh Data**: re-runs every BlueGamma formula on the active sheet with the latest data. To update another sheet, open it and click **Refresh Data** again.
* **Calculation Mode**: click the settings (cog) icon at the top right of the task pane.
  * **System** and **Automatic** always fetch the latest data when a formula recalculates.
  * **Manual** reuses values fetched within the last hour, which is faster for large workbooks. Click **Refresh Data** to force fresh values.

The same settings menu has **Auto-refresh FX** (**Off** by default). Set it to **Every 10 seconds**, **Every 30 seconds** or **Every minute** to keep every `FX` and `FX_FORWARD` cell on every sheet in the workbook up to date. All other BlueGamma formulas keep their values until you click **Refresh Data**.

The settings icon appears once you're signed in, and **Refresh Data** once your account has add-in access.

***

## Lost password or signed out

If you've been signed out of the add-in and can't remember your password:

1. Go to [app.bluegamma.io](https://app.bluegamma.io) in your browser
2. Click **Sign in** → **Forgot password?** and follow the reset link sent to your email
3. Once you've reset your password, return to Excel, click the **BlueGamma** button on the **Home** tab and sign in with the new password

If you're not sure which email your BlueGamma account is registered under, email <support@bluegamma.io> from the address you think you used and we'll check.

***

## Login button not working

If the login button in Excel isn't working, this can happen on work laptops with extra security settings. You can still log in using your browser.

### Steps

1. In the Excel add-in, click **"Having issues logging in?"** (under the login button).

<div align="center"><figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2Fgit-blob-eee60a8fb964bf39d2049e1c70021b3f4879eac8%2Fexcel-task-pane-signed-out.png?alt=media" alt="The BlueGamma task pane signed out, with the Login button and the Having issues logging in? link below it"><figcaption></figcaption></figure></div>

2. Click on the authentication link that appears
3. Your web browser will open the BlueGamma login page.
4. Sign in as usual.
5. A **code** will be shown on the screen.
6. Copy the code.
7. Go back to Excel and paste the code into the box.

<figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2FfAm0M1ZEKVnjF7HunnxA%2FScreenshot%202025-09-08%20at%2010.30.43.png?alt=media&amp;token=727d1add-c019-4ccf-bec3-fd7a6d10974a" alt=""><figcaption></figcaption></figure>

8. Press **Confirm**.

You should now be logged in.

### Why this happens

Some laptops block the pop-up login window inside Excel. The manual login uses your browser instead.

***

## Still stuck?

If none of the above solutions work, contact us:

* **Email:** <support@bluegamma.io>
* **In-app chat:** Available at [app.bluegamma.io](https://app.bluegamma.io)

When contacting support, please include:

* The exact error message you're seeing
* Your Excel version (File → Account → About Excel)
* Whether you're using Excel Desktop or Excel Online
* Any screenshots of the issue


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://www.bluegamma.io/documentation/integrations/excel-add-in/troubleshooting.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
