This workbook contains features that prevent it from using autosave

Question

How on earth do I fix this? It keeps reoccurring on different but similarly structured workbooks. They are too large and complex to keep copying the data to new workbooks every time. What am I doing that is making this keep happening?

Answer 1

Hi @Lauren Crowe

You may try to click File > Info > Inspect Workbook > Check Compatibility, uncheck the box of "Check compatibility when saving this workbook", and then Save As a new workbook.

Please note, macro-enabled workbooks, protected workbooks, and those with external data connections often disable autosave to ensure the integrity of the workbook and maintain security measures.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---