Additionally, you now have the option to make changes to the data in Excel and send it back to Business Central. The “Edit in Excel” option, like the “Open in Excel” option, creates an Excel file with the data on the Business Central page.
![microsoft dynamics pos excel integration microsoft dynamics pos excel integration](https://hellodax.files.wordpress.com/2016/07/installation.png)
This is a great feature for Business Central users who are used to build reports in Excel and prefer its interface for their data analysis. Simply open the page you’re interested in, and click “Open in Excel.” From here, you’ll have the option to open the resulting Excel workbook immediately or save it to your computer. The option to open your data in Excel is available from any Business Central journal, list, or worksheet. Therefore, use this feature only when you don’t plan to make changes and publish them back into Business Central. It’s important to note that this is one-way. The “Open in Excel” option sends the Business Central page to Excel for further analysis. It visually explains the three main concepts of using Excel with regard to your items in Business Central. The following illustration shows the item list in Business Central. If you love Excel, you’ll love Business Central. Editing data directly before publishing it to Business Central.Copying and pasting data directly into your Business Central environment.How Excel Can Be Used in Business Central Let’s explore the different options for using Excel with Business Central. Microsoft Dynamics 365 Business Central users can connect Excel into Business Central for flexible, familiar data editing and reporting. If you’ve been working with Excel for many years, you’ll be happy to know that Microsoft Dynamics offers a variety of ways to use it in combination with Business Central.
![microsoft dynamics pos excel integration microsoft dynamics pos excel integration](https://us.v-cdn.net/5022383/uploads/editor/x5/gb9f53dmo12p.png)
![microsoft dynamics pos excel integration microsoft dynamics pos excel integration](https://news.microsoft.com/wp-content/uploads/2012/02/02-01AX_sm93B5C73F_Page.jpg)
Thanks to Microsoft Excel’s popularity and long-standing presence in the office, the spreadsheet tool has a large, loyal following.