Skip to content

Why can’t AutoSave work with a macro in a Word or Office document ?

Autosave in Microsoft 365 and Office is one of the more frustrating features with annoying limitations.  One of them is not automatically saving any macro-enabled Word, Excel or PowerPoint file.

We’ve talked before about how Autosave is used to push customers into using OneDrive to save documents.  Autosave could work for all files, not matter where they are saved but Microsoft has chosen to use it as an unsubtle way to force cloud storage.

Remove that big AutoSave from the Office toolbar

Is AutoSave really the ‘greatest feature of all time’?

About Microsoft Office AutoSave, AutoRecover and other save options

Microsoft keeps finding other ways to annoy customers including anyone who has macros in their documents, sheets or decks.

Macro enabled Office files (docm, xlsm or pptm) won’t Autosave!  Grrrr

It’s hard to see any technical reason for this limitations except perhaps that it would cost Microsoft a little more development money.

With AI coding becoming commonly available, more people are adding macros to their documents.  So this unnecessary limitation needs to be addressed.

About this author

Office-Watch.com

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.