XLS and XLSX exports fail with a page limit error, or return a blank page

Exports from Anaplan to Excel fail with an error message:

You can only export up to 1370 pages from Anaplan to an XLS file. Reduce the number of pages or choose a different file type.

(This occurs for .xls exports).

Export format does not support more than 10000 pages

(This occurs for .xlsx exports).

These errors will occur if the total number of Pages in the Module to be exported exceed the following:

• 1,370 for export to Excel (.xls)
• 10,000 for export to Excel Open XML (.xlsx)

I.e. if there are 5 lists with 10 list items each as page selectors in a module with 1 line item, the total number of pages will be 100,000 (10^5) - this will lead to the error.

If the export is performed through the User Experience, the user will see a blank page instead of an error.

Use "Show Selected" to only display the current items and export that.

For example, you have List 1 and List 2 as page selectors in a module, with 100 items each (giving 10000 pages), and you wish to export the current page to XLSX or XLS.

If the current selection is Item A for List 1 and Item B for List 2, then pivot both lists from page selectors to rows (nested with the dimensions already on rows).

Select Item A from List 1, right-click and choose "Show Selected". Repeat this for Item B from List 2. You then effectively have a 1 page module corresponding to the item from each list, which can be exported successfully.

 An alternative workaround is to export the data to CSV format.