EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB37421: Excel sheet name start with ".xls]" when exported to Excel 2003 from MicroStrategy Web 9.0.x and 9.2.x


Community Admin

• Strategy


SYMPTOM:
After a report is exported to Excel without formatting, the sheet name found as a number like YYYYMMDDHHMMSS.exp instead of the actual report name in Strategy Web 9.0.x as explained in the following Technical Note:
 
KB19099 - When exporting a report to Microsoft Excel, the report name is not generated correctly in Strategy Web 8.1.x
 
However, after the suggested action taken, the name in the tab now starts with ".xls]"
 
STEPS TO REPRODUCE:
Execute the following in Strategy Tutorial:

  • Follow KB19099 to change the export behavior.
  • Export any report from 9.0.2 Web to Excel without formatting.
  • Check the sheet name and confirm the name appear as .xls]ReportName(1)
ka04W000000OaW4QAK_0EM4400000027Ve.png
  • ** Issue reproduced with Excel 2003. If Excel 2007 or 2010 is used, the sheet name has Report_Name(1).

CAUSE:
 
This is a known issue with Strategy Web 9.0.x and 9.2.x.
 
 
ACTION:
 
Contact Strategy Technical Support for an update regarding this issue.
 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017