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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / NAV 2013 cannot export...
Microsoft Dynamics NAV (Archived)

NAV 2013 cannot export the list to excel 2007

(0) ShareShare
ReportReport
Posted on by asat 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

I have the same question (0)
  • Neville Foyn Profile Picture
    Neville Foyn 4,320 on at

    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

  • asat Profile Picture
    asat 195 on at

    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

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at

    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

    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

  • Neville Foyn Profile Picture
    Neville Foyn 4,320 on at

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

  • rhansen Profile Picture
    rhansen 2 on at

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

  • sharjs4u Profile Picture
    sharjs4u on at

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

  • Verified answer
    sharjs4u Profile Picture
    sharjs4u on at

    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

     

  • Gem Profile Picture
    Gem 5 on at

    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.

  • Suggested answer
    CGeorge Profile Picture
    CGeorge 5 on at

    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.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans