Microsoft Dynamics NAV (Archived)

NAV 2013 cannot export the list to excel 2007

(0) Share

Report

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

All responses (10)

Answers (1)

Suggested answer

CGeorge 5 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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 on at

Like (0)

Report

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 on at

Like (0)

Report

RE: NAV 2013 cannot export the list to excel 2007

Did you find the solution my friend? We have similar issue here
rhansen 2 on at

Like (0)

Report

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 4,320 on at

Like (0)

Report

RE: NAV 2013 cannot export the list to excel 2007

Sorry not sure then, perhaps one of the other guys has an idea?
asat 195 on at

Like (0)

Report

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 4,320 on at

Like (0)

Report

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 195 on at

Like (0)

Report

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 4,320 on at

Like (0)

Report

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