Many times I have wished there was an option to print a Dynamics NAV / Navision report to Excel but there are only a select few reports that come out of the box with this capability. I have, in the past, saved the report as HTML then opened that in Excel. This does work, to some extent, but often requires quite a bit of time consuming re-formatting and clean up.
I’m excited to say that we have become aware of a better option to pull a Dynamics NAV / Navision report into Excel. Save the report out of Navision as an HTML file and then open that in Excel as previously stated. From this point, save this file as a .csv (comma delimited) file. Open the newly saved .csv file in Excel and you will get the data in a much more manageable format with a lot less cleanup and re-formatting required.
Give this a try and let us know how you make out.