+ Reply to Thread
Results 1 to 4 of 4

How to make restoration of corrupted excel 2007 file?

  1. #1
    Registered User
    Join Date
    07-23-2014
    Location
    Duisburg, Germany
    MS-Off Ver
    2007
    Posts
    0

    How to make restoration of corrupted excel 2007 file?

    Hi there,

    When I open an excel file the following error message is displayed: “The file may be corrupted, located on a server that is not responding, or read only”. Since this happened whenever I open any excel file, the above error message is again displayed, I must also mention that I am sure my files are not read-only and the files are stored on my hard disk and I use VM ware and my OS is windows server!

    How can I solve this problem?

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: How to make restoration of corrupted excel 2007 file?

    Hi,

    Please go through the below link, this will help you for sure:

    1) http://www.techrepublic.com/blog/10-...xcel-workbook/

    2) http://office.microsoft.com/en-in/ex...010097017.aspx


    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Registered User
    Join Date
    07-24-2014
    Location
    Canada
    MS-Off Ver
    14
    Posts
    1

    Re: How to make restoration of corrupted excel 2007 file?

    When an Excel file is corrupted, then you can try several methods to recover it:

    1. First of all, you can try to repair the file manually in Excel, as follows:

    (1) On the File menu, click Open.
    (2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
    (3) Click Open and Repair, and then choose which method you want to use to recover your workbook.

    You may find more information about this at:

    http://office.microsoft.com/en-us/ex...001034656.aspx (for Excel 2003)
    http://office.microsoft.com/en-us/ex...017.aspx?CTT=1 (for Excel 2007)
    http://office.microsoft.com/en-us/ex...840.aspx?CTT=1 (for Excel 2010)
    http://office.microsoft.com/en-us/ex...554.aspx?CTT=1 (for Excel 2013)

    2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro, as below

    http://office.microsoft.com/en-us/ex...#_Toc337637262

    3. Third, there are also free tools from third-parties that can open and read Microsoft Excel files, for example,

    3.1 OpenOffice at http://www.openoffice.org. This is a very famous open source project that is designed to support Office file formats, including Excel files. The software can run under Windows.

    3.2 KingSoft Spreadsheets at http://www.kingsoftstore.com/office/free-excel. This is a free Windows tool that can open Excel files.

    3.3 Google Drive at https://drive.google.com/ also support to load Excel files.

    Sometimes when Excel fails to open your file, these tools may be able to open it successfully. If that is the case, then after the Excel file is opened, you can just save it as a new file which will be error-free.

    4. For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools such as WinRAR at http://www.rarlab.com to repair the file, as follows:

    4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
    4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
    4.3 Rename a_fixed.zip back to a_fixed.xlsx
    4.4 Using Excel to open a_fixed.xlsx.


    There may still be some warnings when opening the fixed file in Excel, just let ignore it and Excel will try to open and repair the fixed file. If the file can be opened successfully, then you can just save the contents into another error-free file.

    5. If all above methods do not work, then you may try third-party tools such as DataNumen Excel Repair at

    http://www.datanumen.com/excel-repair/

    I have used it to recover some Excel files successfully. It provides a free demo version so that you can try to see if the data you want can be recovered or not.

    Good luck!

  4. #4
    Registered User
    Join Date
    07-24-2014
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2013
    Posts
    1

    Re: How to make restoration of corrupted excel 2007 file?

    Hi,

    It's very improbable that all your Excel files get corrupted at the same time. I'd bet on issues with Excel installation, viruses or hardware problems, in this order. But in this last case you should experience the same things with other file types.

    1st recommendation: do a redundant backup now, i.e., 2 copies in removable media

    2nd one: copy a few files and test them in other computers and/or upload them here

    3nd one: uninstall and reinstall Excel

    4th: ran an online antivirus, then update your AV definitions

    5th: same for malware detectors (i.e., Spy Bot Search & Destroy)

    6th: general backup

    7th: format disks and reinstall Windows and software

    If in any step you find a solution then you're safe, with less or more work but safe. If still in the same conditions, well, I started saying it was very improbable, but not impossible. This Excel file can be retrieved back with the help of Recovery Toolbox for Excel which is designed with advanced algorithm to recover all your data from corrupted spreadsheet document.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to repair and recover a corrupted excel 2007 file
    By Gboyeshot in forum Excel General
    Replies: 5
    Last Post: 05-11-2013, 08:25 AM
  2. Auto saving data to the db with subsequent restoration should excel crushes
    By leshka_uk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2012, 08:05 AM
  3. Excel 2007 : Excel 2007 Format Corrupted!
    By fisdara in forum Excel General
    Replies: 1
    Last Post: 01-09-2009, 02:06 PM
  4. Replies: 0
    Last Post: 11-08-2007, 03:49 AM
  5. Excel 2007 Beta 2 thinks our Excel 2003 workbooks are corrupted
    By lkrakauer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2006, 01:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1