Opening report in Excel link returns error "This file is not in a recognizable format' caused by defect PM45355 in Controller 10.1.0.

Technote (troubleshooting)


Problem(Abstract)

User launches Microsoft Excel. User clicks the Controller add-in (inside Excel) and logs onto Controller. User clicks "Controller - Reports" and then chooses "Open report".

User selects a report. User receives an error message.

User clicks OK but nothing happens.

Symptom

This file is not in a recognizable format.


Cause

There are many potential causes for this error.

  • For more examples, see separate IBM Technote #1647017.

This Technote specifically relates to the scenario where the cause is a code production problem (defect APAR PM45355) in Controller 10.1.0.

Resolving the problem

Upgrade to Controller 10.1.1 (10.1.1305) or later.

Workaround

Instead of opening the report from Excel, open report from the 'main' Controller client (CCR.EXE).


Related information

APAR PM45355 - CANNOT OPEN REPORT FROM XLS
1647017 - ** Troubleshooting ** Error 'The file is not

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Controller
Controller

Software version:

10.1

Operating system(s):

Windows

Reference #:

1586399

Modified date:

2013-08-15

Translate my page

Machine Translation

Content navigation