Opening report in Excel link returns error "This file is not in a recognizable format' caused by defect PM45355 in Controller 10.1.0.
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.
This file is not in a recognizable format.
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.
Instead of opening the report from Excel, open report from the 'main' Controller client (CCR.EXE).