Wednesday, April 13, 2011

Open Office Calc problem

Am I the only one who has had this happen? Google comes up blank...

I have a large spreadsheet—sales for the last 24 months, 34000+ lines—that I did a subtotal calculation on. I collapsed the data so that all I see is the subtotals, then I saved it. Now, I reopen the sheet and the subtotals are all there, complete with the formulas in the cells, but I can't expand it to see the detail anymore! I've tried selecting it all and redoing the subtotals, in case the data would reappear. Nope!

Anybody know what I can do? Sure, I can recreate it or restore a backup (I use Time Machine—a wonderful tool!), but I've done lots of stuff on the file since then that I would like to keep...Frustration!!!!!

2 comments:

Tim Bulkeley said...

Do you use Dropbox? It has incremental backups often useful in such circumstances... though maybe the backup tool you mentioned does this also?

jps said...

Rupert,

Yes, I have Dropbox—a wonderful tool. But, Time Machine is local and automatic every hour.

Thanks,
James