Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

NAV 2013 cannot export the list to excel 2007

Posted on by 195

Hi,

Currently i am using office 2010, when i export the list result to Excel, it's fine.

however, all our users are using office 2007, when they export the list to Excel, it doesn't work. the Excel application pop-up, but no any data inside.

Then, i made a testing PC to simulate this situation, Win7 + Office 2007 + NAV 2013, but it works fine, this Office 2007 doesn't have any Service Pack.

I tried to re-install in one of the client machines, same as testing PC. and trying to install Office 2007 without SP and with SP3. However, it is also failed to export the list record to Excel.

Any idea and how could i solve this issue? Thanks.

*This post is locked for comments

  • Suggested answer
    CGeorge Profile Picture
    CGeorge 5 on at
    RE: NAV 2013 cannot export the list to excel 2007

    Hi,

    Just ran into the same problem.

    Fixed it by removing the Microsoft Dynamics NAV Excel add-in.

    completely counter intuitive but go to control panel, programs and features, Microsoft Dynamics NAV, and do Change, add or remove components then client and make the Microsoft Office excel add-in Not available.

    print to excel 2007 will now work.

    you can also search the registry and remove the entry's for Microsoft Dynamics excel add-in, This also works.

  • Gem Profile Picture
    Gem 5 on at
    RE: NAV 2013 cannot export the list to excel 2007

    Hi,

    Did you ever resolve this issue?  I am currently having a similar experience with a customer, whereby I can export a report to Excel with data, but the customer receives an empty report when they do the same.  We have installed all the latest rollups to the customers 2013 R2 database and the customer has the correct file versions in their RTC folder.

  • Verified answer
    sharjs4u Profile Picture
    sharjs4u on at
    RE: NAV 2013 cannot export the list to excel 2007

    Hi Guys,

     

    I have found the solution for this. You need to upgrade it to latest build to resolve this issue as below.

    Thanks.

    Regards,

    Sharjs

     

  • sharjs4u Profile Picture
    sharjs4u on at
    RE: NAV 2013 cannot export the list to excel 2007

    Did you find the solution my friend? We have similar issue here

  • rhansen Profile Picture
    rhansen 2 on at
    RE: NAV 2013 cannot export the list to excel 2007

    Was this ever resolved?  We have a client with a very similar issue using Office 2007 SP3.

  • Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: NAV 2013 cannot export the list to excel 2007

    Sorry not sure then, perhaps one of the other guys has an idea?

  • asat Profile Picture
    asat 195 on at
    RE: NAV 2013 cannot export the list to excel 2007

    actually, I already search all the methods, please read my post carefully.

    My PC (office 2010) -> it works very fine

    Testing machine (Office 2007 without Service Pack) -> it works fine

    User's machines (Office 2007 Service Pack 3) -> doesn't work

    Re-install user's machines (Office 2007 without Service Pack)-> doesn't work

    Re-install user's machines (Office 2007 Service Pack 3)-> doesn't work

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: NAV 2013 cannot export the list to excel 2007

    Hi

    I found the system requirements list for NAV 2013, and it seems that Office 2007 requires at least SP1,

    You will find the system requirements list here:

    msdn.microsoft.com/.../dd301054(v=nav.70).aspx

    What you should perhaps try next is to load office, then use the updater to get it to the latest version and see if that resolves the issue? (There may be bits that it loads beyond SP3 that might resolve the issue)

    Check the verrl last paragraph on this linked page

    office.microsoft.com/.../keep-your-computer-updated-by-using-microsoft-update-HA010080333.aspx

    Let me know how it goes

    Cheers

    Nev

  • asat Profile Picture
    asat 195 on at
    RE: NAV 2013 cannot export the list to excel 2007

    actually, my testing is all related to only 1 list, that is Home -> Customer

    My PC (office 2010) -> it works very fine

    Testing machine -> it works fine

    User's machines -> doesn't work

    Re-install user's machines -> doesn't work

  • Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: NAV 2013 cannot export the list to excel 2007

    Hi

    The first step here is to determine if this is a custom export to excel,

    Please try to send to excel from a list within NAV, secondly go into the GL budget and export that to NAV,

    Do both of these exports also not work?

    and lastly what are you trying to export that is creating the blank excel sheets?

    Cheers

    Neville

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans