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

KB202890: "There was an error saving the file. This extension can not be used with the selected file type." error message when exporting a report to excel from MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


"There was an error saving the file. This extension can not be used with the selected file type." error message when exporting a report to excel from MicroStrategy Developer 9.x

SYMPTOM
When the user tries to export a report to Excel in Strategy Developer 9.x, the user gets the error message "There was an error saving the file. This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type."

ka02R000000kbLnQAI_0EM440000002CEv.jpeg

 
CAUSE
This issue is occuring because the user has specificed a Pre-macro or Post-macro in the Data Menu > Export Options > General tab

ka02R000000kbLnQAI_0EM440000002CEu.jpeg

However the Excel Visual Basic for Applications (VBA) has not been installed on the client machine. 
 
ACTION
Please install the Excel VBA on the client machine where the report will be exported to excel in order to use Pre-macros or Post-macros.


Comment

0 comments

Details

Knowledge Article

Published:

April 13, 2017

Last Updated:

July 17, 2017