Every time I delete a row in a certain worksheet in a Google Sheets spreadsheet, I get the following error:
Can't sync your changes. Please copy your recent edits, then revert your changes.
This occurs in Chrome, Safari, and Firefox, so it's clear that all "fix the browser" type solutions (for example, see here or here) aren't applicable.
This error seems to occur when you hit the 1.02 million character limit (see here), but the total number of characters in my spreadsheet is only 25,468, so that doesn't seem to be the issue for me.
One user encountered this issue with respect to protected ranges (see here) and was able to levy that for a solution. However, this sheet has no protected ranges. For good measure, I also made a copy and removed all users but myself (as owner), and the issue persisted.
One user got around this by opening up the same sheet in a new tab while the error message was up in another (see here), but that did nothing for me.
It seems there may be a workaround by exporting to Excel and then reimporting into Google Sheets (see here), but as this spreadsheet uses some Google Sheets only features that would have to be set up again from scratch, not to mention the various formatting issues that occur with those kinds of transitions, this isn't a workable solution.
It seems that it's also possible to copy the data to a new document to resolve this issue (see here and here). That shares some of the problems of exporting to Excel but also will require redoing numerous named ranges, alternating color formatting, conditional formatting, etc., so it's not a viable solution.
How do you fix this?