This post explains how to set up the Edit in Excel add-in for Dynamics 365 Business Central SaaS. With this set up, users will be able to use the Edit in Excel function across the system. Edit in Excel allows users to copy and paste data into columns and fields to then import into Dynamics 365 Business Central, rather than manually entering data. This can dramatically increase the speed and efficiency of inputting data into the system. Only users that are part of the organization will be able to use the Edit in Excel functionality.
In order to use the add-in to Dynamics 365 Business Central SaaS, the Microsoft Office version should be 2016 or higher.
I will first explain how to set up Edit in Excel for Internet Explorer and Microsoft Edge, and further on I will explain the set up for Google Chrome.
Set Up Edit in Excel – Internet Explorer or Microsoft Edge
First, check off ‘Enable DOM Storage’ found in Internet Options, as shown in the following screenshot:
After that, go ahead and open a new blank Excel workbook. Then go to the Insert tab, and click ‘My Add-ins’:
Check if the Microsoft Dynamics Office add-in is already included in ‘My add-ins’ tab:
If it is not added, go ahead and add it or find it in the Microsoft store and click ‘Add’:
Once it is added, click the ‘Add server information’ option.
Now you can test the Edit in Excel feature by using the function in Business Central where the Edit in Excel option is available:
When the file in Excel opens, enter your Microsoft Office 365 sign in credentials. Then you will be able to add new records, modify existing records, and delete records.
To record changes made in Excel back to Dynamics 365 Business Central, you must publish the file back into Business Central:
Note: as the file exported is the table itself, personalization will not work. The columns information when imported back, however, will be placed in the correct fields.
Set Up Edit in Excel – Google Chrome
To use Edit in Excel through the Google Chrome browser, the steps in Excel will be the same, with a few differences in the browser.
First, in Chrome go to Settings:
Then, type “cookies” in the search bar. After the results appear, click the ‘Site Settings’ option:
Click ‘Cookies’ located below Permissions:
In order to allow Dynamics 365 Business Central Edit in Excel, the user will have to disable ‘Block third-party cookies’ to be able to save and read data:
Now the user will also be able to use Edit in Excel in Google Chrome. The steps within Excel are explained above in the Internet Explorer/Microsoft Edge section.
26 Creative Ways Companies are Using Dynamics 365
Find out how companies like yours are using Dynamics 365 to manage their customer relationships and drive revenue.Get The White Paper