When a report that contains formulas is exported to Excel it can, on occassion, show a #NAME? error message in the cell. This error is generally caused by one of two things.
Protected Views in Excel
At times, having Protected Views enabled in Excel can cause formulas to not render data in cells. Protected Views can be enabled for items being downloaded from the internet, or Outlook, or files located in potentially unsafe locations.
It is possible that just by disabling the Protected Views for internet files can rectify the issue. The steps to follow are:
- Open an Excel workbook
- Click File > Options > Trust Center
- On the Trust Center page click the button for Trust Center Settings
- Choose Protected View
- Try disabling the option that speaks to files originating from the Internet. Afterwards, try downloading the Qvinci report again.
Bad Formulas in the Qvinci Template or Older Versions of Excel Causing Issues
There are times when Excel formulas are supported in one version of Excel, but not in others.
For example, a documented Excel error states that using the IFERROR function in Excel 2013 does not render the output of the formula in the spreadsheet correctly, but rather returns a #NAME? error. This error does not exist if the user runs Excel 2016 however. In cases like this, if the user is on Excel 2013, they should steer away from using the IFERROR function in lieu of another.