When exporting Results from Model Development Studio to Excel, the result values are shown with the '#Name?' broken function. To fix this, do the following:
1. In Excel, navigate to the "Developer" tab (this may need to be added in the Excel options).
2. In the Developer tab, select Visual Basic. This will open the Visual Basic coding window.
3. Select the Workbook in the right panel:
4. Select Tools > References. This will open the References dialog.
5. Check the MonetExcelReporting checkbox and click OK and then Save.
6. In the Excel Spreadsheet window, navigate to Formulas and select Refresh Values. This will refresh the spreadsheet and display the result values.