Install Excel Bridge

Prev Next

In Beta

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

This article covers R365 Excel Bridge, an Excel plug-in separate from the Excel plug-in for AI Dashboards (in beta).

Install Excel Bridge and sign in from inside Microsoft Excel. Users with Windows can use the Windows installer to install Excel Bridge. The installer can be found below. To install the Excel Bridge plug-in on Windows or Mac manually, users need the XML manifest file. This file can be obtained by downloading the file below.

Excel Bridge requires Microsoft 365 installed on the user's computer. The required version is 2002 or later on Windows, or 16.35 or later on Mac. The following do not support Excel Bridge: Office 2016, Office 2019 (any license), volume-licensed Office 2021 or earlier, and Excel on iPad.


Excel Bridge Files

Windows Installer

R365ExcelBridgeSetup
6.25 MB

Excel Bridge XML (For manual install)

R365 Excel Bridge
4.70 KB

Prerequisites

The following are required in order to install Excel Bridge:

  • Custom Financials Enabled

    Excel Bridge is only available to organizations with custom financial reporting (CFR).

  • Excel Bridge XML Manifest File
    To install the Excel Bridge plug-in manually, the XML manifest file can be found above.

  • Permissions
    To use the Excel add-in, access is required. See the Security section for details.


Security

Users must have the following permissions to sign in and run formulas:

  • Reporting → Custom Financial Reports → Reports → Create Reports in Excel using the R365 Excel Add-in

  • Administration → Locations → View Locations

  • General Ledger → GL Accounts → View GL Accounts

  • General Ledger → Budgets → View Budgets

    This permission is needed to run R365.BUD formulas. Budgeting & Forecasting must also be enabled for the organization. If Budgeting & Forecasting is not enabled, reach out to your CSM.

These permissions can be added to custom user roles or individual users. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. For more information, see User Setup and Security.

See Set Up Access to Excel Bridge for how an administrator grants these.


Install Using the Excel Bridge Installer (Windows)

Install Excel Bridge on Windows with the R365 installer, which handles the manifest and Trust Center steps automatically.

Important: sign in with the same Windows account

If Windows requests approval under a different account than the one used for Excel, select No. Restart the install while signed in as that user. Otherwise the add-in registers to the wrong account and Excel cannot find it.

Ensure that the Excel application has been closed and quit before starting the installer.

1) Download the installer R365ExcelBridgeSetup.exe. Expand for the download.

This installer is only for use with Windows. Installing Excel Bridge for Mac requires a manual install.

R365ExcelBridgeSetup
6.25 MB

2) Open the R365ExcelBridgeSetup.exe file to run and approve the Windows prompt.

The Windows prompt may first ask to allow the app to make changes to your device. Click Yes to continue.

3) On Welcome to the R365 Excel Add-In Setup Wizard, click Next.

4) On End-User License Agreement, select I accept the terms in the License Agreement, then click Next.

Next stays disabled until the user accepts the terms.

5) On Select Installation Folder, keep the default location or click Browse to choose another, then click Next.

The default location is C:\Program Files (x86)\Restaurant365\R365 Excel Add-In\.

6) On Ready to Install, click Install.

7) Wait for the install to finish.

This may take several minutes.

8) On Completing the R365 Excel Add-In Setup Wizard, click Finish.

9) Reopen Excel to a new blank workbook.

All Excel windows should be closed and quit before reopening Excel.

Select a blank workbook.

10) From the new open blank workbook, click Add-ins from the Home tab.

11) At the bottom of the list, click Advanced….

12) In Office Add-ins, in the SHARED FOLDER tab, locate and click R365 Excel Bridge. Then, click Add.

If R365 Excel Bridge does not appear in the list, click Refresh and wait for the confirmation message.

13) Confirm the R365 button appears on the Home ribbon. Excel Bridge can now be used. Learn more about how to use the plug-in with the quick start guide.


Install Manually On Windows

Use this method only if the installer cannot be used.

Click steps to expand for additional information and images.

1) Download the manifest file and store the file in a new folder.

R365 Excel Bridge
4.70 KB
  1. Once the file has been obtained, download the Manifest File.

  2. Once the file is downloaded, store the file in a new folder created specifically for the storage of the manifest.

2) Share the folder and copy its network path.

To do this:

  1. Right-click the folder

  2. Select Properties

  3. Open the Sharing tab.

  4. Click Share, confirm the owner, and click Share again.

  5. Copy the Network Path, which starts with \\

Important: use the network path

A local path such as C:\... fails with "Cannot connect to catalog." Use the network path instead.

3) Open Excel, and click Options.

Options can also be clicked from File → Options.

4) From the Trust Center open the Trust Center Settings.

5) Open Trusted Add-in Catalogs.

6) Paste the network path into Catalog URL and click Add catalog.

7) Select Show in Menu for the new catalog, then click OK twice.

8) Close Excel completely and reopen it to a new blank workbook.

Ensure that all Excel windows are closed before reopening.

9) On the Home tab, click Add-ins, then Advanced….

10) In Office Add-ins, in the SHARED FOLDER tab, select R365 Excel Bridge, and click Add.

The R365 button appears on the Home ribbon.

11) Confirm the R365 button appears on the Home ribbon. Excel Bridge can now be used. Learn more about how to use the plug-in with the quick start guide.


Install Excel Bridge for Mac

To install Excel Bridge for Mac, download the XML file.

R365 Excel Bridge
4.70 KB

Then, follow these steps:

Click steps to expand for additional information and images.

1) Open the Finder application.

2) Navigate to Users/<Username>/Library/Containers/MicrosoftExcel/Data/Documents

Troubleshooting Notes:

  • If in finder, you don't see usernames, Go to Finder >Settings, then select show Hard disks.

  • The Library folder within the home directory is hidden by default. To make it visible, press Command + Shift + Period (.)

Step by Step Manual Navigation

  1. Open the home folder.
    In the Finder's menu bar, click Go then Home. This will open the User folder.

  2. Reveal the Library Folder.
    The Library folder within the home directory is hidden by default. To make it visible, press Command + Shift + Period (.)

  3. Click the Library folder to open it.

  4. In the Library folder, find and open the Containers folder.

  5. In the Containers folder, find and open the Microsoft Excel folder.

  6. In the Microsoft Excel folder, find and open the Data folder.

  7. In the Data folder, find and open the Documents folder.

3) Create a new folder and name it Wef.

If a Wef folder already exists, continue to step 4.

4) Copy the manifest file to the wef folder.

Troubleshooting Note

If the manifest XML file is unable to be selected (greyed out in the finder), users may need to convert the XML file to the XLAM filetype in order to continue.

5) Close and reopen Microsoft Excel to a new workbook.

6) On the Home tab, click the My Add-ins button, and choose R365 Excel Bridge.

7) Verify that R365 Excel Bridge add-in appears in Excel.


FAQ

Which installation method should I use for Excel Bridge on Windows?

Use the R365 installer method for most Windows installations — it is the primary method and handles the manifest and Trust Center setup automatically. Use the manual method only if the installer cannot be used, such as when IT policy blocks running installer files.

Why doesn't R365 Excel Add-In appear when adding it in Excel?

If R365 Excel Bridge does not appear in the Office Add-ins SHARED FOLDER tab, click Refresh and wait for the confirmation message before trying again. See Excel Bridge Troubleshooting if the add-in still does not appear.

Where do I find my tenant name to sign in?

The tenant name that identifies which Restaurant365 company Excel Bridge connects to. It is the same as your R365 URL. Ex: [tenant].restaurant365.com.

I signed in successfully, but my formulas show errors. What's wrong?

A successful sign-in confirms the connection to R365, but formulas can still return errors if the company's financial reporting database has not finished setup or if there are missing required fields or invalid location IDs. See Excel Bridge Troubleshooting for how to resolve formula errors.

How do I uninstall the plug-in?

If the XML file was used to install, remove the XML file from the folder created for the file.

To uninstall the windows installer:

  1. Run R365ExcelBridgeSetup.exe again.

    The wizard opens with Modify, Repair, and Remove options. Repair fixes missing or corrupt files and registry entries. Use it if the add-in stops appearing in Excel.

  2. Click Remove, then click Remove again on the confirmation screen.

  3. Wait for the removal to finish and click Finish.

To remove Excel Bridge from Windows Settings → Apps instead, find R365 Excel Bridge (publisher: Restaurant365) and select Uninstall.

See Excel Bridge Troubleshooting if the add-in does not appear after installing or reselecting it.