--- title: "Board for M365 Excel Add-in enhancements 15.1" slug: "board-for-m365-excel-add-in-enhancements-15-1" updated: 2026-08-06T12:25:23Z published: 2026-08-06T12:25:23Z canonical: "help.board.com/board-for-m365-excel-add-in-enhancements-15-1" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.board.com/llms.txt > Use this file to discover all available pages before exploring further. # Board for M365 Excel Add-in enhancements 15.1 ## Localization of official languages The Board M365 Excel Add-in now supports 5 official UI languages: French, German, Italian, Japanese, and Spanish. To change the Board Add-in UI language, change the preferred language in your Excel options. When Excel is set to one of the supported languages, the Board Add-in UI automatically appears in that language. > [!NOTE] > The sign-in page remains in English. > [!NOTE] > This language setting applies only to Board-specific Add-in UI. Excel UI language settings are managed separately in Excel. For more information, read the [system requirements article](/v15/docs/system-requirements-and-technical-prerequisites#language-compatibility1). ## Board for M365 Excel Add-in is now compatible without Subscription Hub The M365 for Board Add-in now supports **cloud-based Board environments without the Subscription Hub**. To enable the Add-in without a Subscription Hub: 1. Access the **Profile page** under “Security” in the System Administrator section. 2. Locate the **License section**. 3. Enable the "**M365 Add-ins**" checkbox. > [!NOTE] > This checkbox is **enabled by default for Power User and Developer** licenses. > > For all other profile licenses, you must enable the checkbox manually and have enough of the required M365 Add-in licenses available. ![User profiles for Power User and Lite licenses with associated permissions and settings.](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/m365.add-in.profiles.enable.license.w-o.subhub.png) For more information, read the [system requirements article](/v15/docs/system-requirements-and-technical-prerequisites#board-license-requirements). ## Version management Board introduces **version validation** to prevent users from opening workbooks created in one Add-in with the other. Because Board supports two Add-ins, MS Office and Board for M365, **users cannot use a workbook made for one Add-in while using the other Add-in**. With the release of Board for M365 Excel Add-in, Board already manages version validation one way: when a workbook is created with the MS Office Excel Add-in, it cannot be used with the Board M365 Excel Add-in. With the 15.1 release, Board now manages the following version validation as well: - Any **workbook created with the Board M365 Excel Add-in cannot be used with the MS Office Excel Add-in**. > [!NOTE] > Board supports both the MS Office Excel Add-in and the Board M365 Excel Add-in on the same device. > > Users can **install both Add-ins and switch between them** at runtime without the need to restart Excel or reinstall an Add-in. Read more about [version management](/v15/docs/m365-add-in-install#version-management1). ![](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/image(597).png) ## Security export settings The new option "**Deny MS Office Add-in export**" is now available to ensure the **user exports a Table only compatible with the Board for M365 Excel Add-in**, avoiding accidental exports compatible only with MS Office Add-ins. ![Microsoft 365 Add-ins Workspace with options to deny various features, including MS Office export.](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/m365-deny-ms-office-add-in-export-features.png) **Deny MS Office Add-in export**. This setting **restricts users from exporting** Data Views or Screens **to the legacy MS Office Add-ins**. The option is removed from the export window. Find this new option in the security profile settings created in the "**Features**" section, under "**Microsoft 365 Add-ins Workspace**". > [!NOTE] > The option is **enabled by default** for newly created profiles. > > To disable this option, you must manually uncheck the option of a profile in the Features area. ![](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/image(596).png) For more information, read the [system requirements article](/v15/docs/system-requirements-and-technical-prerequisites#permission-and-role-settings-for-workbooks). ## Copy/paste Sheet Selection and Layout You can now **copy and paste Sheet Selections and Layout configurations** across multiple workbooks. > [!NOTE] > Sheet Selections and Layouts can be copied and pasted across workbooks only when you are signed in with the **same account** and use the **same Platform URL**. **Copy a Sheet Selection** from an existing sheet and paste it into a new sheet, or use it to overwrite an existing one with the same Data Model. The "Copy Selection" option is in the **Sheet Selection menu options**. After clicking "Selection" in the ribbon, click on the 3 dots next to "Sheet Selection". > [!NOTE] > Sheet Selections can only be pasted into sheets that use the **same Data Model**. > > If you paste a Sheet Selection into a workbook that uses a different Data Model, the selection does not apply and a message appears. To paste the Sheet Selection, you must change the Data Model to match the source sheet. ![Menu options in Layout Editor, including Copy Layout and Clear Layout features.](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/m365-excel-add-in-copy-layout.png) ![Sheet Selection dropdown menu for copying a selection.](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/m365-excel-add-in-sheet-selection-copy.png) **Copy a Layout** from one Table and paste it into a new or existing Table, matching the copy and paste behavior already available between Flex Grid Objects. The "Copy Layout" option is in the **Layout Editor menu options**. After you click on "Edit Layout", click the three dots next to "Layout Editor". Read more about [Sheet Selection](/v15/docs/m365-excel-addin-data-selection#copy-and-paste-a-selection) and the [M365 Excel Add-in Layout Editor](/v15/docs/table-layout-editor) article. ## Board for M365 Excel Add-in now supports Calculated aggregation functions The **Calculated aggregation function** is now available for Algorithm Blocks. The Calculated aggregation function can be used in two ways: - from the Set subtotal aggregation option in the Values area for Algorithm Blocks only. - from the Block settings in the Layout Editor for Algorithm Blocks with "Hide Block" enabled only in the "Main options" area. > [!NOTE] > The Calculated aggregation is **only available for Algorithm Blocks** in a **Layout**. > > Aggregation functions are **not supported for Dataset**-based Tables. > [!NOTE] > When setting an aggregation function to a Block other than Algorithms, "Calculated" is omitted from the list of options. Read more about Calculated aggregation in Table Layouts and Pivot Tables. **Export to M365** **now supports calculated Algorithms**. A new option, "Use Excel formulas for calculated Blocks, column totals and row totals", is available when you export a Flex Grid from Board to use in Board for M365 Excel Add-in. This option lets Excel formulas interact with Blocks that use the newly supported Calculated aggregation function. Read more about [aggregation functions](/v15/docs/aggregation-block-settings). ## Improved export Export to M365 has **improved in functionality and UI** for more **reliable workflows** and to provide specific notifications to help users identify and **resolve export issues**. The export to M365 Excel Add-in now: - supports **calculated Algorithms** - has improved “**Export formatting**” - has **improved UI** to make export settings clearer and easier to use. ![Instructions for exporting data to Excel with allowed and blocked properties listed.](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/m365-add-in-export-window.png) Read more about the [M365 Excel Add-in export](/v15/docs/export-to-m365-excel-add-in). ## Refresh loader progress indicator The Board for M365 Excel Add-in now provides users with clear **progress updates directly in the task pane** when you refresh a workbook, sheet, Table, selection, or other content. For refreshes that take longer than 2 seconds, the loader shows: - the total number of Tables refreshing, - how many Tables are complete, - the name of the Table currently in progress, - the time needed to draw cells in Excel so users know when the refresh is fully complete. #### Resolve Table Refresh Failures In addition to the progress loader, **if a Table refresh fails**, Board automatically opens the Table list, highlights the affected Table cards in red, and provides more details. ![Refresh Workbook progress loader](https://cdn.document360.io/8d6f1ae8-0cac-4d0d-a208-6245b83df94a/Images/Documentation/m365.add-in.loader.gif)