If you are unable to create a new account, please email support@bspsoftware.com

 

Value displayed as #name? in Excel 2016 (work fine in Excel 2010)

Started by Hemix, 21 Aug 2020 06:52:50 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Hemix

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)
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite