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

Excel repair for Mac

Help!


My very important budget-file is corrupted! I use Excel for Mac 2008 on my Macbook (Mac OS X 10.6.8). I recently used the file but now when I want to open it it says 'The file you are trying to open is possibly read-only or the location you are trying to open is read-only. Or the server you are trying to access is not responding'.


I'm afraid the file is corrupted 😟


What is strange is that there are two other files which all of the sudden have the same issue, all 3 files have the .xls extension instead of .xlsx which I can open without a problem.


I didn't do anything myself to these files?! So is it a question of corruption of wrong extension? No idea!


I've allready tried searching for a program that can repair corrupted excel-files but they don't work on my Mac, are all for Windows OS.


Can anybody help?? I'm getting really desperaty here! It's a very important budget-file, and ofcourse my back-up with Time Machine is from after when i last used the file 😟 😟


Any help would be MUCH appreciated!

MacBook, Mac OS X (10.6.8), excel for mac

Posted on Sep 17, 2011 4:37 AM

Reply
Question marked as Best reply

Posted on May 21, 2015 8:39 AM

I tried all of these recommendations to no avail. I even went as far as to buy a file repair application (it just crashed repeated). In the end I found that I could open my Excel file in Numbers! I then exported from Numbers back to Excel and voila! Problem solved!


Hope this helps someone!

17 replies

Aug 19, 2012 9:46 PM in response to Kaatfrombelgium

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.

May 23, 2013 5:09 AM in response to Kaatfrombelgium

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

Sep 12, 2013 5:31 AM in response to Kaatfrombelgium

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.

Sep 24, 2014 2:05 AM in response to ibizamauigirl

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.


Thanks!

Nov 29, 2014 1:34 PM in response to lastobelus

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


Damaged File


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.


Lost File


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


Source: http://www.excelrepairtoolbox.com/

Excel repair for Mac

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