Feeds:
Posts
Comments

Posts Tagged ‘Integrating NAV with Excel’

A good post by a west coast NAV blogger provides steps for integrating your Dynamics NAV (in this case, 2018, though it should work basically the same for other versions) with Microsoft’s Excel spreadsheet.  The end result is a new, separate “Dynamics NAV” tab in the ribbon of your Excel application that links directly to NAV.

[Disclaimer: While some users may be able to handle this one on their own, feel free to contact us or your authorized NAV partner to installation assistance if it will make you feel safer.  Also note that this is specifically for NAV (in particular, though not exclusively, the 2018 version), and presumably not for the new Business Central.]

Step 1: Locate your installation file (that’s your NAV ‘setup’ file). The file location may vary depending on how and where your NAV is installed (you might be able to get help from your IT folks, or call us).

Step2:  Double-click the file name (setup.exe) and when asked “Do you want to allow this app to make changes to your device?” click the “Yes” box.

Step 3: From the Maintenance setup wizard, click “Add or remove components” which will open a box listing a lot of application parts under the heading “Customize the Installation.”

Step 4: From the listing, click the down arrow in the little box associated with “Microsoft Excel Add-In.”

Step 5: When the little down-arrow box opens, click “Run from my computer” and then click “Next.”

Step 6: You will see a screen of specified parameters and, assuming these are correct, click “Apply.”

Step 7: NAV will then run the function to enable the add-in and you should see a Microsoft Dynamics NAV information screen that says: “The modification of Microsoft Dynamics NAV has completed successfully.”

 

Again, while it’s pretty simple, we always suggest you have a knowledgeable NAV/tech support person available to you whenever making changes to your system.  Assuming all goes well, you’ll end up with a Dynamics NAV tab in the ribbon of your Excel for fast NAV access!

Our thanks to Encore Business blogger Eunice Gan who posted this tip/article, with screen shots here, originally.

 

Read Full Post »