Exporting Reports to Excel – Microsoft Dynamics Nav Tip

When you go into a report, if there are no options to export to excel you can save the file as html then open with Microsoft Excel.

 

When in the report, enter your filter criteria, then go onto File>Save as HTML. 

 

Open Excel then locate the file you have saved and open (ensure the file type has been changed so you can see the .htm files)

 

To reformat:

 

Select the whole of the document and right click and select Format Cells….

 

Click the Alignment tab and in the Text Control area make sure everything is un-selected (Wrap text/Shrink to fit/Merge cells, click ok.

 

You will now be able to sort on the data

Leave a Reply