Friday, January 4, 2019

Print Send To Excel do not export all columns

Few weeks ago, I ran into a strange issue and in this blog I will discuss the issue and the solution which worked for me.

I got a requirement to add the salesperson code and sell-to customer name to the salesline page, since those fields are not part of the salesline table, I have added the code on the salesline list page to retrieve the salesheader record and display those values on the page.

Everything worked well, but when we try to use the Print –> Send to Excel option those custom fields are not available on the excel.  Couple of users were able to get those fields on the excel but not all the users.

Initially I thought it could be a permission issue on the sales header table but that was not the case, even user with SUPER permission has the same issue. We have checked if the excel version is different between those users but that’s not the case, everybody is running the same version.  I have searched the Cumulative updates if there is bug or fix for that kind of error but unfortunately I have not found anything related.

I have found a standard page which uses the similar kind of logic, the page is “Customer Order Lines Status” with ID 10010 which uses the same kind logic which it displays the status from the salesheader table and I have ran into same issue with that page, all fields were exported except the salesheader fields.

Finally, I saw one difference between the users who are able to export all the fields and other, and that is the DynamicsNAV menu on the Excel, The users who have the DynamicsNAV menu are not able to export all the fields, so I went ahead and disabled the DynamicsNAV Add-on.

Voila, that resolved the issue.  I have not uninstalled just disabled it, if you uninstall nothing will export.  I am not sure what is the reason but that resolved my issue.

Here are the steps to disable the add-on

1. Open Excel, Go To File –> Options

2. Select Add-Ins and in the bottom select the Go beside Mange Add-ons

3. Uncheck the box for the Dynamics NAV and Click Ok

DisableNAVAddIn

I hope this will help others who run into the same issue.

Please leave your comments/suggestions.



Share:

9 comments:

Unknown said...

Hi,

I found also a same issue,
i want to inactive the microsft dynamics NAv Add-in but after restart the excel it will in again active List.
Please suggest Dynamic Nav Tab is will not get disable from Excel.

Thanks You.

Ramiz Arshad said...

Hi,
The reason that I thought why its not exporting for some users with NAV add in enable was because of Page variables.
IF you have some page variables and try to export with NAV add in enable it will skip the data of page variables why because of extension.
With extension enable you can resend or update data to NAV but data always reflect back (insert/modify) to table fields not the page variables.
I think thats why its not working. Correct me if I am wrong.

Thanks

Anonymous said...

Thanks.
This helped in solving other Excel Add in issues as well.

VenkoG said...

Excellent post

Laura Bush said...

Thanks for sharing this article here about the excel sheet printing. Your article is very informative and I am impressed by the details that you have shared in this post. Keep sharing these types of articles here. how to double space in word

Erwin said...

Thank you so much for this article. It solved my issue and of my colleagues.

Dreamsoft Consultants said...

A big thanks for sharing this post by the way if anyone looking for Best Consulting Firm for Fake Experience Certificate Providers in mumbai, India with Complete Documents So Dreamsoft Consultancy is the Best Place.Further Details Here- 9599119376 or VisitWebsite-https://experiencecertificates.com/experience-certificate-provider-in-mumbai.html

mcamanish said...

very helpfull

Unknown said...

Hi,
I tried your solution by simply unchecking Dynamics NAV but now my excel sheet is blank after I export.
Note : I have not disabled add on as you mentioned.
Any Idea?
Missing fields are variables as mentioned by Ramiz Arshad above.