Fix for Google Sheets error message: “Can’t save your changes. Copy any recent changes, then revert to an earlier revision”

If you come across a message that Google Sheets can't save your sheets and you need to revert to an earlier version, but even the earlier version can't save, don't bother doing any of these suggested steps. Clearing cookies won't help. Disabling extensions won't help.

Instead, try this (as counterintuitive as it seems): copy and paste your Google Sheets cells into a new Excel workbook. Save the Excel workbook and upload it to Google Drive. Open it with Google Sheets. Save that sheet. Delete your old, non-working sheet.

Join the Conversation

6 Comments

    1. Well, this is a workaround, not a fix, so you may have to put a little more work into the workaround. Copy and paste the text from your Google Sheet and then, after you upload your Excel workbook to Google Drive, try to manually re-insert the images again.

  1. It froze when I tried to copy and when I came back it deleted the recent changes. Can I still retrieve it?

    1. I mean, I’m not Google, so I can’t tell you for sure what’s retrievable and what’s not. Probably the best thing to do would be to look through the version history: File > Version history > See version history.

      Good luck!

Leave a comment

Leave a Reply to Alan Siu Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.