> For the complete documentation index, see [llms.txt](https://docs.openbullion.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.openbullion.com/products/google-sheets-add-on/known-limitations.md).

# Known Limitations

There are a number of known issues/limitations with the Google Add-On. Please see below, or [contact us](mailto:support@openbullion.com) if you don't see your issue listed below:

<details>

<summary>Pricing data is not updating once the Google Sheet is open</summary>

Google Editor Add-Ons, such as the custom `OPENBULLION()` function, have a known limitation in that they only update their data in two scenarios:

* When the sheet is opened/refreshed
* When the inputs of the `OPENBULLION()` function change

The simplest workaround is to reload/refresh your open Google Sheet (typically F5 in your browser) whenever you need to update the `OPENBULLION()` supplied pricing.&#x20;

Alternatively, you can pass the `OPENBULLION()` function data that updates periodically, such as the output from the built-in `GOOGLEFINANCE()` function. Each time a new value is pushed to `OPENBULLION()` via this parameter, it will retrieve updated pricing data.&#x20;

An example:

* Set a fixed cell (A1 in our example) to  `=GOOGLEFINANCE("CURRENCY:USDEUR")`&#x20;
* Pass the value of A1 as needed `=OPENBULLION("XAU", "USD", "OZ", $A$1)`

Now each time that the built-in `GOOGLEFINANCE()` function updates (every \~10 minutes), a new value will be passed to `OPENBULLION()`, triggering a pricing update.

You can see a working demo of this in our '[Periodic Updates](/products/google-sheets-add-on/examples.md#periodic-updates)' example sheet.

</details>

***

*Be sure to* [*submit your email address*](https://forms.gle/uheniL7fQikAuisD9) *to receive product and service updates from OpenBullion.*