Monthly Archives: November 2013

Mac Excel Recovery to Fix Read-Only Error Post Corruption

Microsoft Excel for Mac is a multi-purpose application, which you can use for maintain records as well as recording your expenses and so on. It allows you to use formulas in the spreadsheet for calculations. However, when you add several formulas and macros to the spreadsheet, it becomes very complex and gets prone to corruption. In case of corruption, the entire file becomes inaccessible and you need to opt for Mac Excel repair solutions.

Consider the below mentioned scenarios, which usually occurs while opening an Excel file, to understand this problem:

  • You update an Excel for Mac file, which contains complex budget data, and close the file.
  • When you try to open the file again to make some changes, it becomes inaccessible.
  • Excel for Mac gives you the following error message and file does not open:
    “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.”
  • The problem is with some selected files. All other files open fine.

When you run across this issue, you need to recover Excel files Mac to get your critical data back.

Resolution:

You can sort out this critical issue with the help of following steps:

  1. Repair the disk permissions using the Disk Utility.
  2. Open Excel for Mac application and use Open option to open the file.
  3. Remove Excel preferences and restart the application and then try to open the file.
  4. Change the extension of the file from .xls to .xlsx. This helps in a number of cases.
  5. Restore the file from the most recent backup on the Time Machine or any other storage media.
  6. If nothing works, use third-party recovery application to repair and restore the damaged spreadsheet.

The recovery tools are particularly designed to extract all inaccessible data from the corrupt Excel files. The software can restore all file objects, including charts, text, colors, formatting, and so on. You can use free demo version of the application to check features and functionality of the application and see preview of recoverable files.

By Subhash Chandra