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

The list of available Add-ins in 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

3 Answers

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

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.

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:

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy