BeyondERP.Newsletter
Menu

Setup step on the Excel workbook designer page · Common

Design an editable Excel workbook

Build a workbook from a data entity so users can edit data in Excel and publish it back.

Used by
System user
Business process
Administer system features
Menu item
ExportToExcelWorkbookDesigner
Main table
ExportToExcelEntityListTmp
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you design a custom, editable Excel workbook from a data entity and a chosen set of its fields.
What you do hereUse this page to build Excel workbooks that users can open, edit and publish data back from, and to create blank documents for building Word templates.
ExampleFor example, BEAT's finance team needs to update payment terms on 300 vendors. An administrator selects the vendor entity, adds the key fields, the mandatory fields and Payment terms, creates the workbook, and the team edits the column in Excel and selects Publish.
Excel workbook designer page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathCommon › Common › Office integration › Excel workbook designer
Used next byDocument templates Microsoft Learn
Related pagesDocument templates (Common) Microsoft Learn
In this process Review overridden segregation of duties conflicts · Resolve each segregation of duties conflict
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Design an editable Excel workbook

Build a workbook from a data entity so users can edit data in Excel and publish it back.

Steps from Microsoft

  1. Go to Common > Common > Office integration > Excel workbook designer.
  2. Select the entity and the fields to include in the Excel table.
  3. Make sure all key fields, marked with a key symbol, are included so that edits can be published.
  4. Include all mandatory fields, marked with an asterisk, so records can be created or updated.
  5. Select Create workbook to get the workbook.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
View related formOpens the page that shows the data the entity exposes. It's available only for entities that are linked to a page.Microsoft Learn Opens the vendors page for the vendor entity.
Create workbookCreates an Excel workbook bound to the selected entity and fields.Microsoft Learn
Create blank documentCreates a blank document to start a Word template.Microsoft Learn

Common errors and fixes

MessageWhat to do
Publish fails for edited rowsAdd all key fields (marked with a key symbol) and, for new records, all mandatory fields (marked with an asterisk) to the workbook, then create it again. Microsoft Learn

Test checklist

  1. Select an entity, add all key fields (key symbol) and mandatory fields (asterisk) plus the fields you need, and select Create workbook.
  2. Open the workbook, select Enable editing and check the data loads.
  3. Change a value, select Publish and check the Messages dialog shows one record edited.
  4. Refresh the record in the browser and check the new value is shown.
  5. Remove a key field from the design, edit a value and check that publishing is refused.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Design an editable Excel workbookAlways include every key field and every mandatory field, then the fields to editPublish needs the key fields to find records and the mandatory fields to create them.Who may publish data from Excel?Leaving out a key field: the workbook opens, but edits can't be published.Test: Publish an edit

Feature management and licence

Licence or add-inOn the live system, these roles can open the page: System user, TestEssentialsRole.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyThe designer works on one data entity at a time; the workbook it creates reads and publishes data through that entity. Microsoft Learn
Can it be undoneReversible: The design can be changed and created again; data published from the workbook is changed in the system.
If you change it laterEdits can be published back only when all the entity's key fields are in the Excel table, and new or updated records need all mandatory fields. Microsoft Learn
Technical architect

6Technical

Menu itemExportToExcelWorkbookDesigner Checked in Dynamics 365
FormExportToExcelWorkbookDesigner Checked in Dynamics 365
TableExportToExcelEntityListTmpShown as “Data entities” in Record infoChecked in Dynamics 365
Who can open itPrivilegesOpen in Microsoft Office ExportToExcel
4 security roles AifTestSecRole EventTestRoleSystem user SystemUser TestEssentialsRole
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSystem user SystemUserTestEssentialsRole Give people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=ExportToExcelWorkbookDesigner
Data migrationLoad order: The Excel workbook designer has no data entity in Data management. The designer stores no setup; it creates a workbook from an existing data entity. Keep the workbook file and load it as a document template if others need it.Microsoft Learn
Everyone

8Sources

To cite this step: CMN-OFF-010, Design an editable Excel workbook. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/CMN-OFF-010