BeyondERP.Newsletter
Menu

Setup page · Organization administration

Excel workbook designer

A setup page where you design a custom, editable Excel workbook from a data entity and a chosen set of its fields.

Used by
System user
Business process
Administer system features
Menu item
ExportToExcelWorkbookDesigner
Main table
ExportToExcelEntityListTmp
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 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, you can select Create blank document here to start a new Word template that is later uploaded as an Export to Word experience.
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 pathOrganization administration › Setup › Office integration › Excel workbook designer
Used next byDocument templates Microsoft Learn
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.

Steps from Microsoft

  1. Go to Organization administration > Setup > 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 means
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

Test checklist

  1. Select an entity, add all key fields (key symbol) and all mandatory fields (asterisk), and select Create workbook.
  2. Open the workbook, select Enable editing and check data loads.
  3. Change a value, select Publish and check the change on the related page (View related form).
  4. Create a workbook without a key field and check edits can't be published.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneReversible: The designer only generates a workbook (or a blank document for Word templates). No data changes until someone publishes from the workbook, and you can create a new workbook with different fields at any time. Microsoft Learn
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

5Technical

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

6Developer

Open it by URLhttps://<your-environment>/?mi=ExportToExcelWorkbookDesigner
Everyone

7Sources