# Known Issues - Google Sheets

If you have trouble using [Bkper Functions](https://github.com/bkper/bkper-sheets#functions-reference), the solutions below address the most common issues.

## Where Can I Find the Book ID?

The Book ID is located in the URL of your Bkper Book.

You can also copy it from the [Add-on Sidebar](https://bkper.com/docs/guides/google-sheets/install.md#using-the-add-on-sidebar) or learn more about [finding your Book ID](https://bkper.com/docs/guides/using-bkper/books.md#bookid).

## How to Identify an Error

When executing a function, you may encounter an error. Identify errors by hovering the mouse over cells showing **#ERROR!** or **#REF** results.

## 1. #NAME? Error: Unknown Function

When you copy a Google Sheet that contains Bkper Functions (such as one of Bkper's templates), Google Sheets may not immediately recognize the copied functions. The Sheet displays a **#NAME?** error in cells that call a Bkper Function.

![Google Sheet showing #NAME? error for an unknown Bkper function](https://bkper.com/docs/_astro/known-issues-name-error.CDClLvUi.png)

Often this error clears itself, but it can take up to 24 hours. Try running **Extensions >> Bkper >> Update** to trigger recognition.

If the problem persists, try these solutions (or a combination):

**1. The Add-on is not installed** — [Install the Add-on](https://bkper.com/docs/guides/google-sheets/install.md) from the [Google Workspace Marketplace](https://workspace.google.com/marketplace/app/bkper/360398463400), open it from **Extensions >> Bkper >> Open**, and reload your Google Sheet.

**2. The Add-on hasn't been opened yet** — Open the Add-on once from **Extensions >> Bkper >> Open**.

**3. The spreadsheet copy is broken** — Make another copy of the broken spreadsheet. If this works, you can track [this issue](https://issuetracker.google.com/issues/161245054) for a future fix.

**4. The Add-on installation is broken** — [Remove the Add-on](https://support.google.com/docs/answer/2942256) from Google Sheets and [install](https://workspace.google.com/marketplace/app/bkper/360398463400) it again.

## 2. Error: Invalid Query

![Google Sheet cell showing an Invalid Query error from a Bkper function](https://bkper.com/docs/_astro/known-issues-invalid-query.CSNx-zFW.png)

This means the query you are running is not valid. Copy the query and paste it in the Bkper search bar to verify it works.

Some tips:

- When building dynamic queries with `TEXT()` and `&` concatenation, construct the query in a cell first, then reference that cell in the Bkper function (as in the [Simple General Ledger Report example](https://docs.google.com/spreadsheets/d/1ynzuvDElnz5zLYaMSmANy1t9c4Vv9eKeZ4vXjteGCsY/edit#gid=1349638172))
- Check that the date format in your query matches the format in your Book Settings
- Check quotes around Account and Group names
- Check the operators in the [Query Guide](https://bkper.com/docs/guides/using-bkper/search-and-queries.md)

## 3. Error: Array Result Was Not Expanded

![Google Sheet showing an Array result was not expanded error](https://bkper.com/docs/_astro/known-issues-array-error.OO3OF_Yx.png)

This means the result returned from Bkper needs more rows in your spreadsheet. Select some rows in the middle of the dataset and add more rows until the result appears:

[Image: Adding rows to a Google Sheet to resolve the array expansion error]

**See also:** [Google Sheets Add-on](https://bkper.com/docs/guides/google-sheets.md) | [Bkper Functions Reference](https://github.com/bkper/bkper-sheets#functions-reference)