Skip to main content

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.

Environment

Report Studio

Resolving the problem

Edit the report in Report Studio:

Go on Page Properties, then Miscellaneous section and change the Name property with at least 5 letters.


Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

Cognos Business Intelligence

Report Studio


Software version:
10.1.1, 10.2


Operating system(s):
Windows


Reference #:
1622333


Modified date:
2013-01-14

Translate my page

Content navigation