Numbers document not saving, autosave error

Hello !

Since a few days now i can't save one of my Numbers files. It is quite heavy (52,8 MB), but hasn't been a problem before, and that weight hasn't changed much recently.

When the file opens, i see the running wheel below saying "calculating" and while this is happening, i can modify the file and save/duplicate it. But after a short while, when i try to save it, i get the following message :

The document could not be autosaved. Your most recent changes might be lost.

It is then also impossible to move/duplicate the file without getting that same message. I have copied the file from the Finder to try and save it outside of iCloud, with no avail. I have toggled the file type from single file to bundle with no difference either.

That's an issue I've had in April 25, and the workaround was to... create a new sheet with a pivot table. I suppose it was making making sense to the dev, because it worked, and for months I had an empty sheet with a useless pivot tab le to keep my files (all the heavy ones back then) afloat. Obviously I have tried that trick once more but it hasn't worked. Just for the sake of completeness, I paste below the procedure I received from Apple Support:

Could you try the following workaround: 1. Make a copy of the original file. 2. Add a sheet tab. 3. Enter some data to the table on the new sheet, e.g. enter 1,2,3 to B2,B3,B4. 4. With the cell selected, go to the app menu on the top of the screen - Organize - Create Pivot Table - On Current Sheet. 5. In Pivot Options, check ColumnB. (You should see a pivot table with data created.) 6. Save the file. 7. Close the file and reopen, examine the file and it should be fixed.

I have contacted the support again, but have not received any answer yet.

My config:

Numbers 15.4
macOS 27.0.1
MacBook Pro 16-inch, 2021 w/ Apple M1 Max

Has anyone else encountered that problem? Do you have a magic fix so I can save my file? I'm running a small business and that file is paramount in organizing our customers’ orders and deliveries. We are in the process of transferring it to a more professional solution, but obviously not soon enough.

Thanks anyway!

Arnaud

Posted on Oct 12, 2026 11:00 PM

6 replies

6x6

Level 7 (26,777 points)

Oct 14, 2026 5:59 AM in response to ARMKV

Thanks for giving it a try.

Now, since you can’t duplicate the file, try to create a new (blank) spreadsheet and copy/paste the sheets from the problematic spreadsheet to the blank one. Before proceeding, rename the default sheet “Sheet 1” in the new spreadsheet so that it doesn’t conflict with the sheet names of the original spreadsheet.

6x6

Level 7 (26,777 points)

Oct 13, 2026 4:38 PM in response to ARMKV

Hi Arnaud,

Try to remove a few previous versions of the file.

In Numbers, open your file, click File > Revert To > Browse All Versions, "go back in time" to a version that you don't mind losing, move your cursor to the top of the screen to display the menu bar and click File > Revert To > Delete This Version.

Camelot

Level 9 (62,211 points)

Oct 14, 2026 9:55 AM in response to ARMKV

Are your Numbers preferences set to save your documents to iCloud?

Do you have sufficient space in iCloud?

Can you save a 'clean' copy of the file (hold the option key and choose File -> Save As... and selecting somewhere on your drive, not iCloud (assuming you're not out of space on your internal storage).

ARMKV Author

Level 1 (16 points)

Oct 14, 2026 12:28 AM in response to 6x6

Hello,

Thank you for your suggestion! Unfortunately, it didn't help.

I managed to delete a few versions (the oldest dating back... yesterday, so we've no DeLorean here.), although it was very slow and unreliable. But after that, i still got that message saying it was impossible to save the file, and all i could do was close it.

ARMKV Author

Level 1 (16 points)

Oct 14, 2026 12:34 PM in response to 6x6

I did as you suggested, and at first it seemed to work... but when computation was done, it was all the same. Now that I have a full copy, I try removing sheets and formula to see if the problem could come from a specific content and/or formula...

ARMKV Author

Level 1 (16 points)

Oct 14, 2026 12:32 PM in response to Camelot

I saved it on and out of iCloud, to no avail. I have plenty of free storage both on my computer and on iCloud, so that doesn't seem to be the issue here.

Originally posted at discussions.apple.com/thread/256375240