If the report in Excel comes out with a number of #Value or #Null results, check the below


The BIExcelFunctions addin was the reason that Cisca's machine did not allow the Excel document to appear correctly.

Fix is as follows:
Confirm which version of Excel is in use 32 or 64bit
Go to "\\hlgcjhbfs01\Share\Evo Reporting\BIC_copy1.zip"
Open Zip and copy BIExcelFunctions1.1 and paste in C:\Program Files (x86)\Common Files

Open Excel, File --> Options --> Add-ins --> Manage Excel Add-ins --> Go
Browse to C:\Program Files (x86)\Common Files\BIExcelFunctions1.1\(Correct version)\Sage.BI.ExcelFunctions1.1.xll

As an extra precaution, enable all Macros under Trust center