Exporting to Excel – Microsoft Dynamics Nav Tip – Version 5 onwards

There are certain invalid characters that will not export to excel


: \ / ? * [ or ] 


If you have created a G/L, Customer, Vendor or Bank Account Name that includes one of the above characters then go into Ledger Entries and Export to Excel you will get an error relating to the Workbook Setting.


You will need to rename the G/L Name code and ensure it does not include one the above characters.


Leave a Reply