Configuration Issues

These issues are related to configuration and setup.

Convert to Formulas does not show value
You can create an Exploration View without experiencing an error, but when you convert that exploration sheet to formulas, cells no longer display values properly. In one of the cells that has no value, you click the cell and it shows the COGVAL formula, such as =COGVAL($C$1, $C$2, $B10, C$8, $B$8). Attempting to do this on another workstation you find that values are displayed correctly. If a user with administrative rights to the workstation attempts to convert to formulas, the values are displayed correctly in the cells of the worksheet.
Update server and package designations to make a server available
After changing the gateway alias or switching from a test to a production environment you receive the following error message advising you that the server is not available and that the Cognos® gateway is unable to connect to the IBM® Cognos Analytics server.
The Cognos Office interface fails to initialize in Microsoft Office
IBM Cognos Office may not initialize when the Microsoft .NET Framework is not installed or the version is not correct. The required Microsoft .NET Framework version is 4.6.1 or later. Another possible reason for this condition is that the add-in is either not installed or not registered.
Cognos for Microsoft Office Fails to Initialize
If you use Internet Explorer to browse IBM Cognos Analytics and open a workbook, document, or presentation published by IBM Cognos for Microsoft Office, the document launches in Microsoft Office, but without full functionality.
Microsoft Office does not open a Microsoft Office document published from Cognos Office
If you observe Microsoft Office trying to open a published document twice when you double-click the workbook, document, or presentation from Microsoft Windows Explorer, the file association is either corrupted or not installed properly.
Unable to Open Published Microsoft Office Documents from Cognos Connection
If the browser does not prompt you to open or save the workbook, document, or presentation, it may mean that the option to prompt before opening was cleared. Reset this option.
.NET Messages are not in the installed .NET Framework language
When you install a non-English version of .NET Framework in a non-English operating system, you will notice that the error messages, .NET shortcut, and .NET Console are in English.
Workbook closes unexpectedly
If you install the COM add-in and your Microsoft Excel workbook name contains brackets, [], Excel stops responding or closes unexpectedly after opening.
Reports unavailable in Cognos Connection jobs after using Save As command in Cognos Report Studio
After opening a report in IBM Cognos Report Studio and saving a copy using the Save As command, you may find that if the report is included in a job, it is not available in the IBM Cognos Connection portal.
The content of the Custom Report shows #NAME?
When building a Custom Report, the content of the cells shows #NAME?

Parent topic: What are some common errors when installing Planning Analytics for Microsoft Excel?