Exporting Analysis Views to Excel

You can export your analysis view to Microsoft Excel. There you can analyze and work with Navision data using the full range of features in Excel.

To Export Analysis Views to Excel:

  1. Open the Analysis by Dimensions window.

  2. On the Options tab, in the Show field, select either Actual Amounts or Budgeted Amounts. If you select Budgeted Amounts, the Show Amount field must contain Amount.

  3. Fill in the rest of the fields on the tabs. For help about a specific field, click the field and press F1.

  4. Click Functions, Export to Excel.


The maximum possible number of lines in Excel is approximately 65000. If your analysis view generates too many lines, an error message will appear in Excel.


In Excel, the column headings always display the code. If you place a check mark in the Show Column Name field in the Analysis by Dimensions window, the column headings will display both code and name in Excel.