Apple’s latest innovation—Numbers TELLS me when it malfunctions! “Cannot Save Spreadsheet”

Okay. I debugged it without any help from Apple’s coding team. The error should make clear “Why” the failure is occurring. I.e. “Too many tables in sheet 1 ”.

To debug, I took my best guess, and started going back in time. I realized I had added small tables around one tab’s main table to use as a quick copy and paste of dates as well as a means of tracking percentage changes of my stock portfolio.

THAT was the issue. I finally had to delete about a dozen small, two cell subtables and 5 or 6 tables with maybe 50 cells each.

Now it is able to save again. A Baffling limitation.

Look, you introduced Autosave. I clearly indicated that the “Save” function was the issue.

i eliminated the iCloud issue by saving it to the iPad itself, so also not relevant.

But thanks for chiming in.

Thanks for the well wish, SG.

Any time there is an immediate resolution to a persistent problem after an action, there is a very solid reason to connect the two.

So, I’m going to state that the small tables I added (actually to two tabs) WERE in fact the cause of the Save Failure, any doubts you may express to one side.

Additional data is that deleting the larger, small tables in tab1 allowed the Sheet to Save. But the problem became intermittent then, and while it was failing to Save again, I went ahead and deleted the rest of the small tables in tab2 and it immediately was able to save. It’s had no problem since.

This is a clear example of Cause and Effect, and really doesn’t need doubt to be cast in an offhand way. Other users who may come along later and find this solution should feel confident in implementing this workaround.

Cheers,

HJ

Well, it works until it doesn’t. Clearly it depends on the complexity of your task.

Oh, and again, I eliminated it being a cloud drive related issue by looking at the new copy on my iPad. So, that question is answered.