--- title: "Excel Bridge Quick Start Guide" slug: "excel-bridge-quick-start-guide" status: "new" updated: 2026-11-18T22:09:44Z published: 2026-11-18T22:09:44Z canonical: "docs.restaurant365.com/excel-bridge-quick-start-guide" --- > ## 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 Quick Start Guide In Beta This feature is in [beta](/doc/docs/user-research). 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](/doc/docs/install-excel-bridge) is complete. Read it before working through the full formula references in [Write GL Formulas](/doc/docs/use-r365-gl-formulas) and [Write Budget Formulas](/doc/docs/use-r365-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. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-G9BU220D.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=6T0YtToSi0uCupC2zH0OrPW4JB%2BTITdpN7HENn8zMNU%3D) ****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](/doc/docs/use-r365-gl-formulas) or the [budget formula](/doc/docs/use-r365-budget-formulas). ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-J9CNAOSH.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=CdvIMDjdi83I5kEafk%2Fhudlv7%2FW8xaMdC9IfSbQlZB8%3D) ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-UD8CKTH3.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=2b4DftJydTtJJAybxQd4SzfkYy1nk5QYbWEDn%2F2Xj9Y%3D) > [!TIP] > 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. > > ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-HM8U3371.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=Ay3GYLxeI766NajnMjZagfblNMTwjiY%2FeuKHIO3j4d8%3D) ****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. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-C5SIHT8B.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=WKTxzY%2FGg6lt8PtZ%2FoCKMjBO8DhqfNtC2XaCosT8%2FKk%3D) Once refreshed, the data will pull. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-QWJZ9XAR.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=CKhdsUyDyzJf4XUevajieIz4Acustb3YkXlsgiR7yLE%3D) If a formula shows an error instead of a number, see [Excel Bridge Troubleshooting](/doc/docs/excel-bridge-troubleshooting). --- ## Sign in ****1)** Click **R365** on the **Home** ribbon.** The task pane opens showing **Sign in to R365**. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-H4BLCX7H.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=pCKu08r%2F%2BWzY%2FKEPLwcXZu3X1dKeqeJDNPoYuD78ofk%3D) ****2)** Enter the **Tenant name** and click **Continue**.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-DE6FGI7T.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=9Ts2Ez7LO33bIawcaO846t5EePNc2R2CO3ScF7Lx0ms%3D) 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. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-YEIXWI63.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=GzN51bzt%2FP9R8YBjw%2BKOx1XFkYx1l54tBtBIVZwLpl0%3D) ****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. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-DWT995BS.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=9qSvE1IC7zMkHJlP2ecbcN9wRakQLaHlGIoS5auoC9k%3D) --- ## Switch companies Excel Bridge connects to one R365 instance at a time. ****1)** Click **Sign Out** in the task pane.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-30EXSBMW.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=qkfx1g1xLQ9KwS%2FcCIsxmH5tETXqDflopIHZqWyIKRM%3D) ****2)** Click **R365** on the **Home** ribbon and sign in with a different tenant name.** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-QS7C5F8V.png?sv=2026-02-06&spr=https&st=2026-11-18T22%3A58%3A06Z&se=2026-11-18T23%3A58%3A06Z&sr=b&sp=r&sig=SJaCzIfGnRWN317U0Kh3k2Sb9l9Vg2DyP2HJv8rYdv8%3D) --- ### 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](/doc/docs/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](/doc/docs/use-r365-gl-formulas) for the full set of arguments a GL formula accepts.