12 Replies Latest reply: Jun 22, 2015 6:11 PM by KelvinMason
Kaatfrombelgium Level 1 Level 1 (0 points)

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
  • Badunit Level 6 Level 6 (11,400 points)

    Time Machine keeps older versions, not just the most recent.

  • Jerrold Green1 Level 7 Level 7 (29,945 points)

    A good first thing to do is Permissions Repair in Disk Utility.app

     

    Jerry

  • ibizamauigirl Level 1 Level 1 (0 points)

    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.

  • Hassan Essaili Level 1 Level 1 (0 points)

    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

  • anaxmac Level 1 Level 1 (0 points)

    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.

  • Jeffrey Tashman Level 1 Level 1 (0 points)

    Your suggestion worked, I couldn't understand why it would, but it did.  How did you find this fix?

  • lastobelus Level 1 Level 1 (0 points)

    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!

  • marifilps364 Level 1 Level 1 (0 points)

    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. 1. Log on to your computer and open Microsoft Excel. Click on the "File" menu.

     

    1. 2. Choose "Open" from the list. Browse to the damaged file and highlight it.

     

    1. 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.

     

    1. 4. Save the recovered spreadsheet to your hard drive or network share. Save a backup copy of the spreadsheet as well.

     

    Lost File

     

    1. 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.

     

    1. 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/

  • Badunit Level 6 Level 6 (11,400 points)

    Marifilps364, the instructions you provided are for the Windows version of Excel running on Microsoft Windows. The software you linked to is for Windows only.  Useful information but not applicable to Macs.

     

    This post has some long legs. First post was in 2011.

  • lanuguita Level 1 Level 1 (0 points)

    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.

  • defender96 Level 1 Level 1 (0 points)

    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!

  • KelvinMason Level 1 Level 1 (0 points)

    I had similar issues - DLL error no matter what I tried. I had previously installed a 2nd copy of excel - and for some reason this worked.