Monthly Archives: September 2013

Recover Excel Files Mac to Fix “Excel could not open filename.xlsx” Error?

Are you unable to open a Mac Excel spreadsheet? Do you get “Excel could not open file” error message? This problem most frequently occurs, but not limited to, with the Excel for Mac files after you import data into the spreadsheets. The error message indicates corruption to the spreadsheet and you have to opt for Mac Excel recovery solutions to extract inaccessible data.

Consider a situation where you import some data from CSV or text files to Microsoft Excel spreadsheet and the spreadsheet becomes inaccessible after that. When you try to open the file, the following error message pops up:

“Excel could not open filename.xlsx because some content is unreadable. Do you want to open and repair this workbook? If Excel cannot repair the file, some data may be lost.”

When you repair Excel file Mac by saying yes to the above error message, you get further message:

“Excel repaired or removed unreadable content from this workbook. Do you want to review or save the loge file?”

You can save the log file here and review the changes made to the file. However, in most cases, the file either remains inaccessible or you lose some of the contents from the file.
This problem most frequently occurs due to:

  • Data Connections to the original file, which you have imported to Mac Excel.
  • Version of the Mac Excel or Office for Mac is not updated with the recent updates.
  • The file was created using the previous version of Mac Excel and is not supported in the current version.
  • The file is damaged — by viruses, improper system shutdown, application malfunction etc. — and is unreadable by Excel.

Solution to this problem actually depends upon the cause. Following is the list of some of the possible solutions:

  • Turn off the Data Connections or move the file to another location.
  • Install the latest updates to Excel Mac and try to open the file.
  • Try opening the file in an earlier version and move its contents to newer version.
  • Restore the file from updated backup.
  • Use third-party recovery applications to repair and restore the corrupted file.

The commercial recovery tools are specifically designed to extract inaccessible data from the spreadsheets. They ensure absolute recovery with the cutting-edge recovery techniques.

By Subhash Chandra

Mac Excel Recovery to Fix Automatic Calculation Mode Issues

Microsoft Excel for Mac allows you to select the automatic calculation mode. This workbook mode enables you to make the changes to Excel workbook and MS Excel automatically recalculates all the affected parts. However, there are some situations, where automatic calculation mode can damage the file, if it is shared on the server. This problem makes the file inaccessible and you have to use Mac Excel repair solutions to extract inaccessible file.

Consider the below mentioned scenarios, which demonstrate this problem with Excel for Mac spreadsheets:

  • You have an Excel file stored in a common repository.
  • Both the users are using different versions of the application, 2011 and 2008.
  • User with Excel 2011 version is able to see the file and its calculations properly.
  • Another user with Excel 2008 version cannot access the references, formulas, and other calculations.
  • To fix this problem, Excel 2008 user saved the file as xlsm file in the same repository.
  • When both users tried to open the newly created file, they faced the same accessibility issues.

It makes your significant data in Mac Excel file inaccessible and you have to recover Excel files Mac using advanced recovery methods.

Cause:

This problem may occur due to:

  • Corruption to the file because of saving it to the server. Excel files are not designed to be edited simultaneously on the server.
  • The automatic calculation mode is not working properly, may be because of preferences corruption in the Excel application.

Solution:

You can fix automatic calculation mode issue by:

  • Saving the file to local hard drive and try accessing it.
  • Remove Excel for Mac preferences, restart your Mac, and open the file.
  • Restore the damaged file from the most recent backup of the damaged file.
  • Use third-party recovery applications to restore damaged file and extract inaccessible data.

The commercial recovery tools are capable of retrieving your precious data in all corruption cases. They restore all file objects, including formulas, formatting, charts, graphics, and more. Such tools do not edit or remove the original data.

By Subhash Chandra