Excel settings for export of reports

If you have problems with viewing exported reports in Excel and get #VALUE or #NA issues, please follow the following steps:

The issue is regarding how excel reades "." and ",". As such the solution is to update those settings in excel.

Here are the steps:

    1. Open Excel

    2. In Excel chose: Options -> Advanced -> Use system separators

    3. Chose dot "." as the Decimal separator

    4. Press OK and you are are all set

See screenshots that illustrate the steps:

                                                                                                                                                                      Next page