Newsroom Update

New features come to Apple services this fall. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers reverted a spreadsheet to an old version

I have a fairly large and complex spreadsheet on numbers. For some dumb reason, it defaults to saving my files on iCloud, which, of course, means you don't have much control over it.


Numbers generally stays open on my computer, because I use this large spreadsheet for modeling business pro-formas. I generally save it after every time I update, but sometimes I forget.


I created Version 7 of my spreadsheet on 6 June 2014. Saved it to iCloud and to my desktop. However, any changes I made since 6 June are saved to the cloud.


Today, when I went to my spreadsheet, it was mysteriously reverted back to the 6 June version, losing nearly 3 weeks of data, formulas, etc. So I try to open up the file from iCloud, and there is my spreadsheet's exact name, but there's a folder and in it are jpeg files, and other unreadable files. I can't open it with Numbers. Can't do anything.


So, I go to Time Machine. Well, of course Time Machine doesn't store iCloud stuff, so I can't find any of the changed files for 3 weeks.


This is ridiculous on so many levels. What corrupted my files on iCloud so that I cannot use them? Maybe I can, and someone just needs to explain it to me. And why can't I have a time machine of iCloud? Cause, I need to go back and get this file.


So, 3 weeks of work down the drain. Can't find anything. And I get paid a ridiculous amount per hour to do this. But that's down the toilet.


Any suggestions? Maybe go back to Microsoft, who despite Excel's annoyances, I know when I save a file there it doesn't go missing.


This is the most ridiculous thing I've ever gone through with Apple.

Posted on Jun 28, 2014 3:58 AM

Reply
Question marked as Best reply

Posted on Jun 28, 2014 4:04 AM

OrangeMarlin wrote:


I have a fairly large and complex spreadsheet on numbers. For some dumb reason, it defaults to saving my files on iCloud,

Why don't you save locally instead?

OrangeMarlin wrote:


So, I go to Time Machine. Well, of course Time Machine doesn't store iCloud stuff, so I can't find any of the changed files for 3 weeks.

Time Machine backs up all files on your Mac, this will include iCloud storage (the local copy of your spreadsheet is saved in ~/Mobile Documents) If yours is not doing that something is wrong with it (I assume that you have made no manual exclusions)

OrangeMarlin wrote:


This is ridiculous on so many levels. What corrupted my files on iCloud so that I cannot use them? Maybe I can, and someone just needs to explain it to me. And why can't I have a time machine of iCloud? Cause, I need to go back and get this file.


So, 3 weeks of work down the drain. Can't find anything. And I get paid a ridiculous amount per hour to do this. But that's down the toilet.


Any suggestions? Maybe go back to Microsoft, who despite Excel's annoyances, I know when I save a file there it doesn't go missing.


This is the most ridiculous thing I've ever gone through with Apple.

I can't tell you what happened, I wasn't by your side this past 3 weeks but you should be able to recover with Time Machine and the local (Mobile Documents) copy. And you can decide where Numbers saves its files, you don't have to take the default choices.

16 replies

Numbers reverted a spreadsheet to an old version

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.