--- title: "Excel Bridge Troubleshooting" slug: "excel-bridge-troubleshooting" updated: 2026-11-18T22:16:50Z published: 2026-11-18T22:16:50Z canonical: "docs.restaurant365.com/excel-bridge-troubleshooting" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Excel Bridge Troubleshooting In Beta This feature is in [beta](/doc/docs/user-research). Contact your CSM to learn more. This article covers errors and messages that are not specific to one formula. See [Write GL Formulas](/doc/docs/use-r365-gl-formulas) and [Write Budget Formulas](/doc/docs/use-r365-budget-formulas) for formula-specific cell errors. Excel Bridge formulas only update when a user clicks **Refresh Sheet** or **Refresh Workbook** in the task pane. Opening a workbook, recalculating, or editing a formula does not pull new data on its own. See [Excel Bridge Quick Start](/doc/docs/excel-bridge-quick-start-guide) for how the hourglass and the last-updated label work. The table below covers the cell states and task pane messages that can appear. --- ## Common Issues | Issue | Cause / Related Setting | Resolution | | --- | --- | --- | | A formula keeps showing an hourglass after a refresh | The user's role is missing the **Create Reports in Excel using the R365 Excel Add-in** permission. | An R365 administrator for the organization can [edit the user's permissions](/doc/docs/custom-user-roles) to add the required permissions to the user's role. | | A formula shows #ERROR and the task pane shows a permission message naming View Locations or View GL Accounts | The user's role is missing the **View Locations** permission, the **View GL Accounts** permission, or both. The task pane message names only the missing permission. | An R365 administrator for the organization can [edit the user's permissions](/doc/docs/custom-user-roles) to add the permission to the user's role. Permission changes can take up to 5 minutes to apply. | | An R365.BUD formula shows Error: Budgeting isn't enabled for this R365 account. | Budgeting & Forecasting is off for the company. Every R365.BUD formula shows this message while it is off. It takes priority over the permission message. R365.GL formulas are not affected. | Reach out to your CSM or R365 Support to turn on Budgeting & Forecasting. The change can take up to 5 minutes to reach Excel. | | An R365.BUD formula shows Error: You don't have permission to view budgets. Contact your R365 administrator. | The user's role is missing the **View Budgets** permission. | An R365 administrator for the organization can [edit the user's permissions](/doc/docs/custom-user-roles) to add View Budgets to the user's role. Permission changes can take up to 5 minutes to reach Excel. | | Every Excel Bridge formula shows #ERROR | Most often an expired session, a missing permission, or an unprovisioned financial reporting database. | Check the task pane message first. Then take the action the message indicates: sign in again, request the missing permission, or reach out to your CSM to provision the database. | | The task pane shows a session-expired message | The R365 sign-in is no longer valid. | Sign in again. | | The task pane shows the database is not provisioned | The financial reporting database that Excel Bridge reads from is not set up for the company. | Reach out to your CSM. | | The task pane shows a request timed out | The refresh request took too long. | Click **Refresh Sheet** or **Refresh Workbook** again. | | The task pane shows data could not be retrieved | A temporary issue retrieving data from the source. | Wait a moment, then try refreshing again with **Refresh Sheet** or **Refresh Workbook**. | | The task pane shows an authentication error with the data source | The cached sign-in is no longer valid for the data source. | Click **Sign Out** in the task pane, then sign in again. | | The task pane shows access to the data source was denied | A permission or account-level restriction on the data source. | Contact an administrator if this continues. | | The task pane shows a request error | An unexpected error retrieving data. | Contact {{variable.R365 Support}} if this continues. | | The task pane shows There are no Excel Bridge formulas on this sheet. | The user clicked **Refresh Sheet** on a sheet that has no Excel Bridge formulas. | Select a sheet that contains Excel Bridge formulas, then click **Refresh Sheet**. | | The task pane shows that the sheet or workbook contains more than 1,000 Excel Bridge formulas | The sheet or workbook is over the limit of 1,000 formulas for one refresh. The message suggests moving some formulas to another sheet or workbook. | Reduce the number of formulas or move some to another sheet or workbook, then try again. See the Limits section in [Write GL Formulas](/doc/docs/use-r365-gl-formulas) or [Write Budget Formulas](/doc/docs/use-r365-budget-formulas). | | Formulas show #NAME?, the refresh buttons do nothing, or Excel asks to update links after reopening a workbook | Excel has not loaded the add-in for this file. | See F[ormulas Show #NAME?, Refresh Does Nothing, or Excel Asks to Update Links](/doc/docs/excel-bridge-troubleshooting#formulas-show-name-refresh-all-does-nothing-or-excel-asks-to-update-links) below. | | Numbers look out of date | Data can be up to about 15 minutes behind R365. Formulas update only on refresh. | Check the last-updated label in the task pane and click **Refresh Sheet** or **Refresh Workbook** again. | | A formula returns an account- or formula-count error | The formula exceeds the account limit. | See the Limits section in [Write GL Formulas](/doc/docs/use-r365-gl-formulas) or [Write Budget Formulas](/doc/docs/use-r365-budget-formulas). | > [!NOTE] > If a resolution here does not clear the issue, contact [R365 Support](https://help.restaurant365.net/support/home) and include the exact task pane message. --- ## Formulas Show #NAME?, Refresh Does Nothing, or Excel Asks to Update Links This happens most often on Office 2016 and Office 2019, which are not supported. If it happens every time a workbook is opened, the first step is to check the Excel version. Microsoft 365 is recommended. **Reselecting the add-in** resolves the immediate issue: ****1)** On the **Home** tab, click **Add-ins**, then **Advanced…**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-CBQC7CZO.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=Co0co2qvgZqZQa98Tfc1ik07O07qm9PHgr1FBfzRr7Q%3D) > [!NOTE] > Reselect the Add In — Excel for Mac > > When using Excel for Mac, the add-in should appear on the **Developer Add-ins** section. > > ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-PNYK77FK.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=bUMrGmL9LuBr18sNo3ySLimYkMOp5C6Phdk6RCJZndQ%3D) ****2)** In **Office Add-ins**, open the **SHARED FOLDER** tab and select **R365 Excel Bridge**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-42OAUDOR.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=JF7aUwq7j87fOpHSF0Tx%2BbYkB%2FfSFbFCAczJfKqEDVg%3D) ****3)** Click **Refresh Sheet** in the task pane.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-ATWLM53A.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=742T4LxpcgoQdEHjbADuKDYuLfra7m3Skkgiih%2BdcyM%3D) See [Install Excel Bridge](/doc/docs/install-excel-bridge) for the full add-in installation steps. --- --- ### FAQ #### Why do my formulas show #NAME? after I reopen a workbook? This happens most often on unsupported Excel versions, such as Office 2016 or Office 2019. Reselecting the add-in from Office Add-ins and clicking Refresh Sheet resolves the immediate issue. See [Install Excel Bridge](/doc/docs/install-excel-bridge) for the full add-in installation steps. #### Why does a permission error appear even though Excel Bridge worked yesterday? A permission error after Excel Bridge previously worked usually means one of three things. A role lost a permission, Budgeting & Forecasting was turned off for an R365.BUD formula, or the R365 sign-in expired. Signing in again resolves an expired session. A missing permission requires an administrator to grant it again. The change can take up to 5 minutes to reach Excel. Review the [user permissions](/doc/docs/excel-bridge-overview#permissions) for the permissions Excel Bridge requires. #### How out of date can the numbers in a workbook be before something is wrong? Data can be up to about 15 minutes behind R365 under normal conditions, because formulas only update on refresh.