4

Every time when I try to save a file, I'm getting the following error message.

Save as Macro-free workbook

The list of available Add-ins in Excel

Add-ins of excel I tested with a fresh file saved with simple word, closed, re-opened and trying to save after changing any letter.

  • I ensured there is no content in VBA editor for the file I'm trying to save. (No other files opened)
  • The default save format in excel option is set to Excel Workbook

. How do I get rid of this save as dialog and save as xlsx file by default?

3
  • 2
    An Excel Add-In may automatically be modifying your notebook. Please provide a list of all add-ins you have installed in Excel.
    – Daniel B
    Apr 7, 2015 at 7:14
  • Unable to select all as a list. Attached as snapshot.
    – Jones
    Apr 7, 2015 at 8:04
  • That’s great! Don’t forget to answer your question, you can accept the answer after a day or so.
    – Daniel B
    Apr 7, 2015 at 10:05

3 Answers 3

5

As Daniel mentioned, MySQL For Excel add-in is causing this issue. Disabling it and restarting Excel fixed this issue and saves without the nagging dialog.

1
  • This deserves, like, a thousand up-votes. What the prank was the Excel team thinking with this default behavior?
    – bwperrin
    Feb 16, 2017 at 20:10
4

Just to clarify, note that MySQL for Excel is a COM Add-in. In Excel 2013, at the bottom of the Excel Options -> Add-Ins page, click on the Manage drop list, and select COM Add-ins. You will then see the checkbox that needs to be unchecked in order to disable this.

3

For anyone else that may stumble upon this issue like I did, and the "COM Add-ins" solution didn't help, try this very simple solution:

Just save your file as "xlsm" instead of "xls". Like this:

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .