Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

OS X Lion 10.7.4. I did work on a Microsoft Excel 2011 spreadsheet (saved in .xls format) and noticed a file on my desktop that said it could not be trashed. It disappeared when I re-started the Finder. But the next time I opened the Excel spreadsheet, the work I had done had been lost — except for a 'sum' field which displays the total from the lost fields but says it contains the function '=SUM(#REF!)'. Perhaps the Excel file on my desktop was a temporary storage file for the new data I added to the spreadsheet. Getting rid of this file may have trashed the data it may have contained. I've just done work on another spreadsheet and a new 'non-trashable' Excel file has appeared on my desktop. I hesitate to re-start the Finder in case I lose the work I have done. Has anyone else experience the same problem, and is there a solution?

share|improve this question

1 Answer 1

There is clearly a bug in Excel 2011 for files on the Desktop where Excel does not clean its scratch files during editing and quitting. Like you, only rebooting seems to get rid of them. The only workaround I have sorted out is to simply not edit Excel docs on the Desktop. I have not seen any data loss issues related to those files on the Desktop.

share|improve this answer
    
Thanks, Philip Regan. I saved my recently edited Excel files in a folder off the desktop and re-launched the Finder. The scratch file disappeared from my desktop and no Excel data has been lost. But I'm still missing the data from the Excel spreadsheet I edited earlier (which I may have edited on the desktop). Any idea about how to recover that data? –  John Burke Aug 21 '12 at 15:44
    
I would imagine some kind of file recovery software would help with getting those files visible, but there is no guarantee you would be able to open them and find anything useful. –  Philip Regan Aug 21 '12 at 16:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.