Excel Bridge Quick Start Guide

Prev Next

In Beta

This feature is in beta. Contact your CSM to learn more.

This article walks through using Excel Bridge for the first time: signing in, writing a formula, and refreshing to see the result. It's the fastest way to see the whole flow once installation is complete. Read it before working through the full formula references in Write GL Formulas and Write Budget Formulas.

Every Excel Bridge formula follows the same three-step loop: sign in, write a formula, then refresh to pull the result from R365.

1) Sign in.

On the Home tab, click R365. The task pane opens. If not already signed in, enter the Tenant name, click Continue, then sign in with an R365 username and password (or the company's sign-in page, if the company uses single sign-on). The task pane shows Connected with the tenant name and user name.

2) Write a formula.

Click an empty cell and type a formula, for example =R365.GL(5000), which pulls the net activity for account 5000 across all locations and all dates. Press Enter. The cell shows an hourglass — Excel Bridge formulas don't calculate on their own.

There are two Excel Bridge formulas: =R365.GL and =R365.BUD. Read more about the GL account formula or the budget formula.

R365 Tip

To see a description of each argument while building a formula, click Insert Function to open the Function Arguments dialog (Windows) or Formula Builder (Mac). Arguments can be entered on this dialog as well as directly in the cell.

3) Refresh to pull the data.

In the task pane, click Refresh Sheet to refresh the formulas on the sheet in view. The cell fills in with a number, and the task pane shows Sheet last updated with the date and time R365 last updated the data. This can be earlier than the time of the click.

Click Refresh Workbook to refresh the formulas on every sheet. The label then reads Workbook last updated. Before the first refresh, the label reads Data last updated: Not yet refreshed.

Until Refresh [Sheet / Workbook] is clicked, cells awaiting values will have the hourglass image.

Once refreshed, the data will pull.

If a formula shows an error instead of a number, see Excel Bridge Troubleshooting.


Sign in

1) Click R365 on the Home ribbon.

The task pane opens showing Sign in to R365.

2) Enter the Tenant name and click Continue.

A window with the R365 login will open.

3) Enter the R365 username and password and click Log in.

A company that uses single sign-on goes to its own sign-in page automatically.

4) Confirm the task pane shows Connected with the tenant name, user name, and Refresh Sheet and Refresh Workbook buttons.

The sign-in stays active after the user closes Excel.


Switch companies

Excel Bridge connects to one R365 instance at a time.

1) Click Sign Out in the task pane.

2) Click R365 on the Home ribbon and sign in with a different tenant name.


FAQ

What if the cell still shows an hourglass after I click Refresh Sheet / Refresh Workbook?

An hourglass just means the formula hasn't refreshed yet — it's expected right after typing a formula, and clicking Refresh Sheet / Refresh Workbook clears it. If the hourglass doesn't clear after a refresh, or a cell shows an error instead, see Excel Bridge Troubleshooting.

What if the task pane doesn't show Connected after I sign in?

A task pane that doesn't show Connected usually points to a sign-in or access issue rather than a problem with a formula. Check that the required permissions and the financial reporting database are set up.

What is the difference between Refresh Sheet and Refresh Workbook?

Refresh Sheet updates every Excel Bridge formula on the current open sheet, and Refresh Workbook updates every Excel Bridge formula in the workbook at once, not just the sheet.

What happens to the formula values when I close and reopen the workbook?

Reopening a workbook doesn't automatically refresh Excel Bridge formulas — click Refresh Sheet or Refresh Workbook again to pull current data.

What does the number in a formula like =R365.GL(5000) mean?

The number is a GL account number — it tells the formula which account to pull activity for. See Write GL Formulas for the full set of arguments a GL formula accepts.