Document Could Not Be Autosaved - Your Most Recent Changes Might be Lost

Hi, this has happened once or twice in the last 113 versions of my file, but seemed to resolve quickly... but this time I cannot proceed (tried for the last hour).... I am in an endless cycle of force quits / unsaved documents etc.

|I used the Option key and "Save As" version 113 (it was v112) and as soon as I do a few edits this warning keeps repeatedly coming back:

"Document Could Not Be Autosaved."

I can't even quit the program now as it says "Not Saved." And it prompts the Duplicate/Discard pop up....

If I hit Duplicate, on the warning, it crashes...

So I have to hit discard...

Why is it saying "Untitled" in the title at the top of the file and yet when I hit File/Rename there is no "Untitled in the name?" Which is it? Untitled or the name I gave it?

A lot of memory is being used too.

Apple Support said that this is a known bug.

The fix apparently is to create a separate tab and make a table with some simple numbers in it. Then go to Organise (top menu) and create a pivot table on the "current sheet," and then tick Column B (to the right). This is the (odd) workaround. I have no idea how this fixes the problem and wish I was working on the document that we created the extra pivot tab table in because the latter document I am working on without the "fix" has now also failed to save....

Any other ideas how to stop this?

Thanks.

Pivot table version also won't autosave. The "fix" doesn't work....

I don't think Apple should ever update anything again until they've properly bug tested it.

I normally wait 6m to a yr before upgrading.

26 yrs of using Apple has taught me that. I should never have gone up to 14.4.

No it's not actually locked. It's definitely a known bug with a strange pivot table fix. Thanks.