Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Hemix on 21 Aug 2020 06:52:50 AM

Title: Value displayed as #name? in Excel 2016 (work fine in Excel 2010)
Post by: Hemix on 21 Aug 2020 06:52:50 AM
OS: Windows 10 x64
Office: 2010 (MSI) and Office 365 (ClickToRun).
Both installed on the same computer.

When opening a report generated by Cognos in Excel 2010 everything works fine.
The same document opened in Excel 365 and all values are displayed as "#NAME?".

Some formulas get added a @ in Excel 365.
Example: =@cc.fCompName(D16)
Text only | Text with Images