BeyondERP.Newsletter
Menu

Setup step on the Office app parameters page · System administration

Set up Office app parameters

Use this page to control how the Excel and Word add-ins are loaded and how many rows are published from Excel at a time.

Used by
Chief executive officer, Information technology manager
Business process
Administer system features
Menu item
OfficeAppParametersPage
Main table
OfficeAppParameters
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 with system-wide settings for the Office add-ins, such as the Excel add-in's app ID, store and publish batch limit.
What you do hereUse this page to control how the Excel and Word add-ins are loaded and how many rows are published from Excel at a time.
ExampleFor example, to deploy the add-ins centrally, an administrator changes the App ID, Store and Store Type values on the App parameters tab.
Office app parameters 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 pathSystem administration › Setup › Office app parameters
Set up firstClient performance options Microsoft Learn
Used next byWorkspaces > Feature management Microsoft Learn
In this process Set up Case processes · Set up Categories
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.

Step by step, with screenshots

Set up Office app parameters1 screen

Use this page to control how the Excel and Word add-ins are loaded and how many rows are published from Excel at a time.

  1. Screen 1

    Review the Office app parameters

    Go to System administration > Setup > Office app parameters

    1. Open the App parameters tab and review the apps listed
    2. Open the Registered applets and Registered resources tabs to review what is registered
    3. Change the number of rows published from Excel at a time only when needed
    Review the Office app parameters (zoomed on the outlined fields)
    Show the full screenReview the Office app parameters
    page title tab to open what to set or check

How to use it

  1. Go to System administration > Setup > Office app parameters.
  2. On the App parameters tab, select Initialize app parameters.
  3. Review the App ID, Name, Version, Store, Store type, Notes and Publish batch columns.
  4. Select Registered applets or Registered resources to see those lists.
  5. Select Save.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Publish batch limitThe most rows an Open in Excel workbook publishes in one batch, for all users.Microsoft Learn 100DataPublishBatchLimit

Common errors and fixes

MessageWhat to do
Users get time-outs when publishing from ExcelLower Publish batch limit; users can also set a smaller size per workbook in the add-in options, but not above the system limit. Microsoft Learn

Test checklist

  1. Set Publish batch limit on the App parameters section.
  2. Open a list page in Excel with Open in Excel, change more rows than the limit, and select Publish.
  3. Check all rows publish without a time-out.
  4. In the add-in options, try a Publish batch size above the system limit and check it isn't accepted.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Office app parametersKeep Publish batch limit at 100 (the default and maximum); lower it only if users get time-outs when publishing from ExcelExcel add-in updates are published in batches of up to 100 rows. The Publish batch limit sets a system-wide cap; users can set a lower size per workbook.How are the Office add-ins deployed?Changing App ID, Store and Store Type for centralized deployment without knowing the Word add-in on Document templates uses the same values.Test: Excel publishes within the batch limit

Feature management and licence

Feature to turn onAllow configuration of the publish batch size in the Excel add-in (Optional)
Licence or add-inOn this system the page opens for Information technology manager and Chief executive officer. IT administrators maintain it. The publish batch size needs the optional feature Allow configuration of the publish batch size in the Excel add-in.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: Values can be changed at any time. Microsoft documents the standard Office Store values (App ID WA104379629, Store en-US, Store Type Office Store) to switch back.
If you change it laterThe App ID, Store and Store Type values are also used by the Word add-in when it runs from the Document templates page. Microsoft Learn
Technical architect

6Technical

Menu itemOfficeAppParametersPage Checked in Dynamics 365
FormOfficeAppParameters Checked in Dynamics 365
TableOfficeAppParametersChecked in Dynamics 365
Who can open itPrivilegesMaintain system parameters SystemParametersMaintainView system parameters SystemParametersViewDutiesMaintain system parameters master SystemParametersMasterMaintainInquire into system parameters master SystemParametersMasterView
2 security rolesChief executive officer CompanyChiefExecutiveOfficerInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerTo use itChief executive officer CompanyChiefExecutiveOfficerGive 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=OfficeAppParametersPage
Data migrationLoad order: Office app parameters has no data entity in Data management, so it can't be loaded from a file or a configuration template. Select Initialize app parameters and set the values by hand in each environment.Checked in Dynamics 365
Table definitionOfficeAppParameters columns and relations Microsoft data model
Everyone

8Sources

To cite this step: SA-SETUP-120, Set up Office app parameters. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SA-SETUP-120