In Beta
This feature is in beta. Contact your CSM to learn more.
This article covers errors and messages that are not specific to one formula. See Write GL Formulas and Write 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 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 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 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 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 or Write 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 Formulas Show #NAME?, Refresh 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 or Write Budget Formulas. |
If a resolution here does not clear the issue, contact R365 Support 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….

Reselect the Add In — Excel for Mac
When using Excel for Mac, the add-in should appear on the Developer Add-ins section.
2) In Office Add-ins, open the SHARED FOLDER tab and select R365 Excel Bridge.

3) Click Refresh Sheet in the task pane.

See 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 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 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.
