Why is a macro-enabled Excel template not allowing AutoSave to be turned on when opened to edit in FYI?

Issue

I am opening a macro-enabled Excel template in FYI. This is not allowing AutoSave to be turned on. The information under the AutoSave message says that it is an older file format and as it is a macro-enabled worksheet, I cannot convert it to a newer version.

Cause

It appears the issue is being caused by the compatibility check being run when saving the document.

Solution

Disable the compatibility check and this should resolve the issue. You can choose to deselect the option to check compatibility when saving the document. To disable this for Excel entirely, refer to this Microsoft article Turn off Compatibility Report.

As this is a Microsoft feature, please also check with your IT consultants.