A
aacross
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a large-ish spreadsheet (2.3mb), one of several linked spreadsheets that I have been working on. Three times today Excel has crashed. The first two times, it allowed me to create a recovery file (XLSB). The third time, after I had made regular saves of the spreadsheet to avoid all the complicated work to re-work the recovery files, it did not offer a recovery, presumably because I had saved it seconds before it crashed again. However, my main file is now totally unreadable by Excel. It refuses to open, giving a message 'Excel cannot open this file - The file might have been damaged or modified from its original format.' I have the latest patches, have tried deleting the Office 2008 directory in the Preferences folder, and also tried renaming the file to xls and xlsb with no joy (this sometimes works, particularly xls).
The stupid thing is, Apple Numbers will open it (albeit with fixed tables as it does not support Pivot Tables), as will Apple Quick View!
Any ideas? I lost two hours work in the last crash, so I am a little reluctant to do it all again, as I have made little progress today!
Also, another related question: What is the simplest way to keep external workbook references intact? Because I have numerous linked workbooks, if I rename them, the linked tables remain connected to the old names. This is one of the problems with recovery files. The best I can think of is to keep a sheet with links to the external workbooks that I can refer to in cells, though I have not tried this.
Many thanks in advance!
Andrew
The stupid thing is, Apple Numbers will open it (albeit with fixed tables as it does not support Pivot Tables), as will Apple Quick View!
Any ideas? I lost two hours work in the last crash, so I am a little reluctant to do it all again, as I have made little progress today!
Also, another related question: What is the simplest way to keep external workbook references intact? Because I have numerous linked workbooks, if I rename them, the linked tables remain connected to the old names. This is one of the problems with recovery files. The best I can think of is to keep a sheet with links to the external workbooks that I can refer to in cells, though I have not tried this.
Many thanks in advance!
Andrew