KB34902: When exporting a report with multiple page bys to Excel, Recovered Sheet will be displayed in the worksheet names in MicroStrategy Web.

SYMPTOM
Reports exported to Excel will display “Recovered Sheet” in the worksheet name if the page-by object contains element names longer than 30 characters.
 
STEPS TO REPRODUCE
Follow the steps below to reproduce this issue in Strategy Tutorial Project:

• Edit the 'Region' datawarehouse table (LU_REGION) to include element names with more than 30 characters.
• Create a report with attributes: Region, Customer State, and Customer.
• Place Region and Customer State in the Page-by field.
• Execute the report.  Confirm the attribute element names have 30+ characters:
   
• Export to Excel with Formatting, making sure to expand all page-by fields and place each page on a separate sheet:
  
   
  

• Once the export is complete, some of the Excel worksheet names will display "Recovered_Sheet'".

 
CAUSE
This is a Microsoft Excel limitation with worksheet character name lengths.
 
ACTION
To avoid such behavior all page-by element names have to be shorter or equal to 30 characters.