KB47056: ’Excel found unreadable content in ’xxxx.xlsx’.’ message appears when opening the exported Excel file in Microsoft Excel 2007/2010 in MicroStrategy Web

SYMPTOM:
 
In Strategy Web, 'Excel found unreadable content in 'xxxx.xlsx'.' message is displayed when opening the exported Excel file in Microsoft Excel 2007/2010, as shown in the image below:

 
STEPS TO REPRODUCE:
Follow the steps below to reproduce the issue with Strategy Tutorial project:

• Create a Report Service document based off ’01 Blank Dashboard’ template.
• Insert a text field and enable Hyperlink with the following URL.
   
  
  Sample Code/Error
  http://xxxxxxxxxx.co.jp/Strategy/asp/Main.aspx?Server=aaa&Project=aaa%EF%BC%9ADTL%E9%96%A2%E9%80%A3%28%E6%A8%99%E6%BA%96%E8%AA%8D%E8%A8%BC%29&port=0&evt=3067&src=Main.aspx.3067&defaultRunMode=excelFormattingGridsIServer&reportViewMode=1&reportID=7431D5CA46C25453F05D24894A1A746E&promptsAnswerXML=%3Crsl%3E%3Cpa%20pt%3D%228%22%20pin%3D%220%22%20did%3D%22740B1DE344B75357B8CAC598DB2AA7E6%22%20tp%3D%2210%22%3E%3Cexp%3E%3Cnd%20et%3D%225%22%20nt%3D%224%22%20dmt%3D%221%22%20ddt%3D%22-1%22%3E%3Cnd%20et%3D%221%22%20nt%3D%225%22%20dmt%3D%221%22%20ddt%3D%22-1%22%3E%3Cat%20did%3D%220F0DEF354002BD06185CCD9D61F25F28%22%20tp%3D%2212%22%2F%3E%3C%2Fnd%3E%3Cnd%20et%3D%221%22%20nt%3D%222%22%20dmt%3D%221%22%20ddt%3D%22-1%22%3E%3Cmi%3E%3Ces%3E%3Cat%20did%3D%220F0DEF354002BD06185CCD9D61F25F28%22%20tp%3D%2212%22%2F%3E%3Ce%20emt%3D%221%22%20ei%3D%220F0DEF354002BD06185CCD9D61F25F28%3A1G014%22%20art%3D%221%22%20disp_n%3D%22%EF%BC%AF%E6%9D%B1%E6%B5%B7%E5%96%B6%22%2F%3E%3C%2Fes%3E%3C%2Fmi%3E%3C%2Fnd%3E%3Cop%20fnt%3D%2222%22%2F%3E%3C%2Fnd%3E%3C%2Fexp%3E%3C%2Fpa%3E%3C%2Frsl%3E&elementsPromptAnswers={&%E7%B5%84%E7%B9%94@GUID};{&%E7%B5%84%E7%B9%94@GUID}:{%E7%B5%84%E7%B9%94@ID}&elementsPromptAnswers=5883F2DC41C9D17A3807AEBD0101761D;&elementsPromptAnswers=082BC44646D9CD71284BA3B2144213D8;    
  
   

• Run and export the Report Service document to Excel 2007/2010.
  
• Note that 'Excel found unreadable content in 'xxxx.xlsx'.' message appears.
  

 
CAUSE:
 
This is a known issue with Strategy Web.
 
ACTION:
 
Contact Strategy Technical Support for an update on the status of this issue.