Error: "We found a problem with some content in 'XXXX.xls'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes" (Doc ID 2379113.1)

Last updated on DECEMBER 04, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.7 and later
Information in this document applies to any platform.

Symptoms

When attempting to export a BI Publisher report with more than 65536 rows to excel the following error occurs and only 65536 rows are present in the file.

ERROR
"We found a problem with some content in 'filename.xls'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

Clicking yes then opens the document in a protected view and only contains 65536 rows

STEPS
The issue can be reproduced at will with the following steps:

Log into BI Publisher
Execute the report
Open the excel output

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot view the full report.

Changes

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

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