OBIEE 11g - Exporting Dashboard Page to Excel Error:"Excel found unreadable content in" FILE_NAME.xlsx. "Do you want to recover the contents of this workbook?" (Doc ID 2095305.1)

Last updated on NOVEMBER 27, 2019

Applies to:

Symptoms

You are trying to Export Dashboard Page to Excel by using Page Options > Export To Excel.

• When you open the exported Excel file, you receive the following error;

Excel found unreadable content in FILE_NAME.xlsx.  Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes.

• and when you click 'Yes' and open the Excel file, you receive the following error;

 Removed Records: Named range from /xl/workbook.xml part (Workbook)

• You notice that the Sheet name in the Excel file has been repaired instead of the Dashboard Page name.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.