?
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
Medium Priority
?
63 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 35

Accepted Solution

by:
Rob Henson earned 2000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
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 …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

599 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