Error when opening Excel output and Excel tab are named Recovered_Sheet

Technote (troubleshooting)


Problem(Abstract)

When opening Excel outputs an error is displayed.
If the output is 2002 it is ok after Excel opens.
If the output is 2007 then Excel tabs will be named Recovered_SheetX

Symptom

Errors when opening Excel outputs:

The file you are trying to open, 'filename', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
---
or
---
Excel found unreadable content in 'filename'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

Cause

The report name page is too short or the report name is too long.

Environment

Report Studio

Resolving the problem

Edit the report in Report Studio:

Go on Page Properties, then Miscellaneous section and change the Name property to be a minimum of 5 characters or a maximum of 31 characters.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Report Studio

Software version:

10.1.1, 10.2, 10.2.1

Operating system(s):

Windows

Reference #:

1622333

Modified date:

2013-11-01

Translate my page

Machine Translation

Content navigation