KB35369: "Specified worksheet may have merged cells in the area to which the report is being exported" message appears when exporting a large report with more than 65536 rows to Excel in MicroStrategy Developer 9.4.x-10.x

Salesforce Solutions Architect • Strategy

This knowledge base article documents why "Specified worksheet may have merged cells in the area to which the report is being exported" message appears when exporting a large report with more than 65536 rows to Excel in MicroStrategy Developer 9.4.x-10.x

SYMPTOM:
Exporting a large report with more than 65536 rows to Microsoft Excel fails with the following error in Strategy Developer 9.4.x-10.x:


Desktop is unable to export to excel. specified worksheet may have merged 
cells in the area to which the report is being exported

CAUSE:
This is a known issue in Strategy Developer 9.4.x-10.x due to the technical limitation of maximum number of rows that can be exported.

ACTION:
Currently there are no plans to address this issue and it is not scoped for any upcoming scheduled Strategy release

WORKAROUND:
In Export Options, check the option of "Use 6.x layout", the report can be exported to Excel successfully, as image shown below:

Alternatively, the export operation can be performed through Strategy Web 9.4.x-10.x.
The Strategy Internal Reference Number for the issue discussed in this technical note is 437952.

Comment

0 comments

Details

Knowledge Article

Published:

June 6, 2017

Last Updated:

June 6, 2017