IBM Support

Excel link spreadsheet reports do not work (all cells change to '#VALUE!' after running report) if their filename contains an apostrophe

Technote (troubleshooting)


Problem(Abstract)

User launches Excel, and logs onto the Controller Excel link. User opens spreadsheet (XLSX file). User presses F9 to run the report. The report appears to start running normally. After a length of time (for example 30 seconds) all the cells (containing fGetVal formulae) change to show: #VALUE!

Symptom

#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!


Cause

Defect (reference APAR PI48774) in Controller.

  • This is triggered when the filename contains an apostrophe (') in it.

Resolving the problem

Fix:

Upgrade to Controller 10.3.1 (10.3.1100.156) or later.

Workaround:

Rename the spreadsheet report's file (XLSX filename) so that it does not contain any 'strange' characters (for example an apostrophe ' ).

Related information

APAR PI48774 - WORKBOOKS WITH AN APOSTROPHE IN THE FILE

Document information

More support for: Cognos Controller
Controller

Software version: 10.2.1, 10.3

Operating system(s): Windows

Reference #: 1966485

Modified date: 27 November 2017


Translate this page: