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.

The user did not use Microsoft Excel before IBM® Planning Analytics for Microsoft Excel was installed and did not get registered properly. There are two ways to resolve this problem. You can give the affected user local administration rights to the workstation or you can run the file Register Cognos® XLL.vbs, which will add the proper registry entries for the new user.

For the Register Cognos XLL.vbs file process to work (both during the installation of the software or when run separately to add a new user) the Microsoft Excel registry entries must have been created by Microsoft Excel itself. You must ensure that the user run Microsoft Excel first, before attempting to add registry entries for IBM Planning Analytics for Microsoft Excel. You can examine the ntuser.dat that the script writes to check whether the user has been properly added.