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
Hi Steve,
NAV 70 uses OpenXml as an add-in (C:\Program Files\Microsoft Dynamics NAV\70\Service\Add-ins\OpenXML). From NAV 71, OpenXml is integrated directly (C:\Program Files\Microsoft Dynamics NAV\71\Service).
Is there any data in table Send-To Program (2000000065) and Style Sheet (2000000066)?
For other tool besides standard export function, you can export Customer List or any List by our Query and Excel Report (community.dynamics.com/.../134939.aspx). Would you like to make an evaluation on NAV80?
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
Hi Steve,
Can you uninstall add in and reinstall it?
Regards,
Saurabh Shah
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.
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
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (