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
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.
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.
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
Did you find the solution my friend? We have similar issue here
Was this ever resolved? We have a client with a very similar issue using Office 2007 SP3.
Sorry not sure then, perhaps one of the other guys has an idea?
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
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156