Solved

Is there any risk my Excel 2007 workbook is corrupted when it suddenly begins being saved as xlsx when always earlier always being saved as xlsm?

Posted on 2016-11-29
2
41 Views
Last Modified: 2016-12-28
This happened after I installed MySQL for Excel. Everything works fine with the installation and I have this add-in in my Excel workbook. And my workbook seems ok, all VBA code is there. But when I save now, I have to change every time from the default xlsx to xlsm. Before the installation the default was always xlsm. Why has this changed, and should I be worried?
0
Comment
Question by:hermesalpha
2 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 41905907
Files with VBA in them have to be saved as xlsm (Macro Enabled Workbook).

To change the default file format option, go to File > Options

In the Left Hand Pane choose the Save Heading and then at the top of the right hand pane there is a drop-down for setting the default file format.
0
 

Author Closing Comment

by:hermesalpha
ID: 41905950
Thanks, that worked.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question