O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Updating NAV data with the Excel add-in

The Microsoft Office Excel add-in enables the user to establish a persistent link between the Dynamics NAV server and an Excel worksheet. This connection makes it possible to update records exported from NAV inside an Excel worksheet.

Getting ready

Microsoft Office Excel add-in is a prerequisite for this recipe. The Excel add-in is provided in Dynamics NAV installation media and must be installed on the client computer on which this walk-through is going to be executed. For details, refer to the recipe Installing NAV Development Environment in Chapter 1, Writing Basic C/AL Code.

How to do it...

In this recipe, we will build a pivot table based on NAV data, and use the Excel add-in to refresh data from the Excel ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required