Numbers update with open files

Just the other day, when Numbers was updated, I had about half a dozen Numbers files open, all of which I use regularly and depend on. These files were in the Numbers folder stored on iCloud remote storage. Once the application was updated, only the forefront file remained open when I relaunched the app. All of the other files had been closed. Or so I thought. When I tried to re-open the files, they were not there! No evidence of their existence in the Numbers folder, or even in the Open Recent… menu item. Luckily I back up regularly, and found them on my hard drive backup. So, case in point, I DO NOT TRUST ICLOUD for safe storage. Something in the Numbers update is amiss, but files shouldn’t have disappeared because of it. I’ve never liked Apple’'s approach to storing app’s files in separate folders which are essentially hidden away.

This would seem like something that could be reproduced! Has anyone here NOT updated to the latest version of Numbers yet? If so, let’s see if we can reproduce @jhewell’s situation.

Can you let us know how many files were open, whether or not they were saved or “dirty,” and what version of macOS you were running? Oh, and what version of Numbers you were updating from?

Thanks for the attention on this.

I had four files open, each with multiple tabs. All had been saved, and the OS is Big Sur 11.2.3. Numbers was at the latest available version just prior to the update to version 11.0 (7030.0.94). The forefront file was actually saved locally on the mac in a different folder from the other three, which were in the Numbers folder within iCloud.

If you go to ‘Recently Deleted’ in the iOS Files app or iCloud Drive on iCloud.com, are the missing files there?

No, they were not. First place I checked when I noticed the issue.

1 Like

Good details! Now all we need is someone who hasn’t already updated to Numbers. I’ll have to check one of my test machines…

I have not, and would be willing to be the guinea pig, but I need the answer to a question I asked in the Numbers update thread. Can Numbers files edited and saved using the new version (11.0) be opened and edited using Numbers 10.3.5? (I’m running 10.3.5 on Mac with Mojave, and apparently cannot update Numbers without updating macOS, which I am loathe to do.) I’m assuming but would appreciate confirmation that Numbers 10.3.9 under iPadOS 14.4.2 would also play well; it does with 10.3.5 on the Mac.

On the other hand, my test would only involve two Numbers files, since that’s all I have. (Much as I would like to abandon Excel, I find Numbers to be too limited.)

Edited to clarify that the Numbers that would be upgraded would be on a MacBook Air running Big Sur. That probably wasn’t clear (he understated).

Just tried it with Numbers 10.0 on my Mojave iMac. Yes, it can open a file saved with Numbers 11.0 from Big Sur, edited, and saved.

1 Like

Confirms my standard operating procedure not to use iCloud for important work. Apple has never got cloud right.

2 Likes

Finally, I got around to this, I thought. (Generally, I only install or update when logged in as admin, and users, including me, only run applications from a user account. Is this unnecessarily cautious?) But read to the end, because my data point might not be meaningful.

I opened my two Numbers spreadsheets (both in iCloud) and created but did not save a third spreadsheet with content in only one cell, then told the App Store to update Numbers. After the update, all three spreadsheets were open and appeared to be intact.

A few hours ago, I clicked the Update button in the App Store for Numbers on my M1 MBA running Big Sur, and I ended up with Numbers 10.3.9. Why didn’t I get 11? Did I get a choice that I didn’t notice about which version to install?

What happens if you check for updates again? Maybe you need to update again to get to 11.0?

If so, try running the open files test again.

It appears so, and I will. I wish I had paid more attention when I updated the first time; that might have shed light on what was going on. I was surprised when I read that @ddmiller mentioned 11 and then I found I had 10 immediately after updating.

I will do that, too. But it will be a while.

To add here, I also had an issue with the first attempt to upgrade Numbers (App Store showed the progress circle, but it never finished and returned to the UPDATE icon. But I didn’t check the files until I tried again to update. Once the upgrade to 11.x succeeded, then I noticed the files had disappeared.