I had the same problem and could not find the answer in this conversation.
I launched Excel,
Open a blank new file.
I set the recalculation option in Excel to Manual in the Tools Menu, OPtions, Calculation tab.
Went in the OPen file Menu and OPened my the File I could not open before. As it was a .xls file a resaved it as a .xlsx file and it seems to work.
send the file as email to one of ur friends who has windows
let them do the open and repair ( open black excel file / file / open / choose file / choose open and repair (there is open button and and arrow , click the arrow to show open and repair button ) / the file will open / save it / let him send it back to your email / open it on your mac and its solved
I have experienced the same problem and was wondering if any software can help me fix the issue. I could not find any software that can repair Excel file on the Mac so I copied the file on Windows and tried demo version of a software. That works up to an extent, but could not recover the formatting.
Then one of my friends suggested me Mac Excel Recovery software from Stellar. It worked like a charm. The software is all i wanted as i face Excel corruption issue very frequently.
This is an excellent tip, and saved me several hours of rework. I had a largish file with some tangly formulas with indirect, dcount/dstdev, averageif, and some array formulas and it stopped opening. Excel would crash with a EXCBADACCESS every time, on multiple machines and the most recent backup that would open meant losing several hours work. After opening it with auto-calculation turned off and saving it and turning auto-calc back on, it stopped crashing Excel on open.
How to recover .xls or .xlsx file, how to open problem ms excel files and some other issues you can find at:- http://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/481-%E2%80%8Be xcel-files-corrupted
How to Restore a Lost Excel Spreadsheet
- 1. Log on to your computer and open Microsoft Excel. Click on the "File" menu.
- 2. Choose "Open" from the list. Browse to the damaged file and highlight it.
- 3. Click on the small drop-down arrow at the right side of the "Open" button. Choose the "Open and Repair" option. Choose "Repair" to have Excel attempt to recover the damaged file. Choose "Extract data" to extract the information in the spreadsheet to another file.
- 4. Save the recovered spreadsheet to your hard drive or network share. Save a backup copy of the spreadsheet as well.
- 5. Search your hard drive for the file. It is not uncommon to save an Excel spreadsheet to the wrong location by mistake. Click on the "Start" menu and choose "Search" from the list.
- 6. Choose the "All files and folders" option and type ".xls" in the search box. This will find all Excel spreadsheets on your computer, whether they were created in Excel 2007 or an earlier version. Click "OK" to start the search.
You also may refer to paid software Excel Repair Toolbox
I followed the suggestion to send the file to a Windows system. Then I changed the extension .xlsx to .xls on Explorer, and proceeded to open the file on Excel. I byassed any warnings to proceed as such, and Excel was able to open the file. I then saved the file as .xlsx, and sent it back to the Mac system.