web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Exporting Customer List from NAV 2015 to Excel 2010

(0) ShareShare
ReportReport
Posted on by 495

When exporting Customer List from NAV 2015 to Excel 2010, I get a blank spreadsheet. Worked fine with ANV 2013 but since installing NAV 2015 no longer works.

*This post is locked for comments

I have the same question (0)
  • keoma Profile Picture
    32,729 on at

    maybe a problem with excel version or 32/64 bit architecture.

  • Mearnsman Profile Picture
    495 on at

    Hi Jonathan,

    Thanks for the quick response. I'm using Office professional Plus 64 bit and it worked perfectly with NAV2013. I've installed NAV2015 alongside NAV2013 and now NAV won't send to Excel from either version. Frustrating. Steve M

  • Suggested answer
    keoma Profile Picture
    32,729 on at

    thats not new. there are some issues betweens nav 2013 and 2015 when installing them side by side. :-|

    workaround: copy the lines in the customer list with select lines/copy row(s). then copy them to excel. to get all columns make them visible in the customer list.

  • Suggested answer
    Saurabh Shah Profile Picture
    4,560 on at

    Hi,

    Please check that you have a "Dynamics NAV" menu available in menu bar (Ribbon) of Excel. There is an add-in which needs to install in excel with administrative rights.

    Steps 1:

    Check that add-in is available in excel so we can install straight away.

    Go to File --> Option --> Add-ins --> Manage --> COM Add-ins --> GO --> select Microsoft Dynamics NAV Add-in --> Press OK

    Make sure that you have administrative rights

    Step 2:

    If you do not find add in then run the Dynamics NAV installation package and add the excel integration component and follow above step again.

    Regards,

    Saurabh Shah

  • Suggested answer
    Daniele Rebussi Profile Picture
    2,480 on at

    I suggest to re-install the Excel Add-in, since as far as I understood you performed a NAV upgrade and the problem can be related to the fact that you are still using the NAV 2013 add-in.

    Not sure about NAV 2015, but I think it could be done running the Microsoft.Dynamics.Nav.ExcelAddin from Role Tailored Client folder.

  • Mearnsman Profile Picture
    495 on at

    Dynamics NAV add-in is there but refers to the "70" folder which is NAV 2013 (although as noted above, can't export direct to Excel from NAV 2013  either).

  • Suggested answer
    Saurabh Shah Profile Picture
    4,560 on at

    Hi Steve,

    Can you uninstall add in and reinstall it?

    Regards,

    Saurabh Shah

  • Mearnsman Profile Picture
    495 on at

    I can't find anything to run relating to Excel in the NAV 2015 RTC folder - only dlls which won't run on their own. Or is there an app to make them run?

  • Suggested answer
    keoma Profile Picture
    32,729 on at

    re-install (remove & new install after restart) the addin by the dynamics nav setup. the component should be (un)selectable. try add/remove components.

  • Suggested answer
    Saurabh Shah Profile Picture
    4,560 on at

    Hi Steve,

    It is available in your installation setup. Run the setup and go to add remove component and select the excel add in under the client option.

    If add in is already install then remove it first and then reinstall it.

    Regards,

    Saurabh Shah

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans