Whilst using mionet with remote excel files - the files have become corrupt
Here are some additional methods:
Opening the file with Open or Libre Office: It has been observed that Open & Libre office are able to open corrupt MS Excel files. These programs are free to download.
Repairing the file with Excel repair software: There are so many data recovery companies that claim they can repair badly corrupt MS Excel files created in MS Excel 2010.
1 - Using "Open and repair"
Microsoft Excel has a built-in repair tool
for corrupted files. To access it, go to File and Open. A menu will pop
up in which you'll have to select the file you want to fix and then
choose "Open and repair" from the dropdown menu. This
will open a dialogue box in which you can pick between the repair option
(which will recover as much information as possible) and the extract
option (that will copy values and formulas). The two alternatives
combined should work fine to save your work.
2 - Saving the file to a different format
If you can open the file but you can't modify it or save the changes, you should use this method. You'll have to save the file to a different format (such as SYLK or HTML) via the "Save as"
menu. Once you've done this, you'll have to open the recently saved
file and then save it once again (but this time, you'll have to choose
the Excel Workbook as the format). By doing this, you'll be creating a
fresh new file with all the data from the corrupted file.
3 - Opening the file in Microsoft Word
This option is only available for the people that have the Microsoft Excel converter installed on their PC (it can be downloaded from the Microsoft website). You simply have to open the corrupted Excel file with Word. However, you should know that this method only works for retrieving data (all the structures from the sheet will be gone, such as formulas and macros).
4 - Altering the Calculation option
If your file isn't opening at all you can try to adjust the calculation option. Simply open Excel in a blank workbook, go to the "Tools" menu and look for "Options". There you'll find the "Calculation" tab in which you'll have to look for the "Calculation" section and set it to "Manual". Click OK and then try to open the corrupted file once again.
5 - Linking the corrupted file
In this method, you'll have to link one cell of a blank worksheet to the corrupted workbook. Be sure to create the new worksheet in the same location as the corrupted file. Once you've done this go to the blank worksheet and enter the following in the A1 cell: <Filename>!A1.
This will copy the data from the A1 cell of the corrupted file to the
new sheet. In case it works, simply click "Edit" on the cell and select an area like the one covers the cell that contain data in the damaged file, and then click Paste. Then (and with the cells still selected) click Copy on the Edit menu.
Get back your excel files applying how to fix corrupt excel 2007
http://www.excelfilefix.com
This solution will help you completely restore the information
If your data did not recovered till now, i would suggest you to try Excel File Recovery Software when you search on Google you will find many results and all websites offering free trial version. One such utility is here.
http://www.recoverydeletedfiles.com/excel-file-recovery-tool.html
Thanks
Microsoft
Excel is a well known spreadsheet application that stores data like
tables, texts, date format, numerical, hyperlinks, texts, unique code
etc. in Excel sheet. There are many reasons due to which these files
get damaged and user face problems. RecoveryFix for Excel Recovery is
the best tool that resolves all issues and gets back your all data
from corrupt MS Excel file.
http://www.excelrepairtool.com
Use in-build "open and repair"utility of MS excel to repair damaged .xlsx files. Follow thesesteps to it
On the File menu, click Open.
In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
Click Open and Repair, and then choose which method you want to use to recover your workbook.
Most probably your problem may get fixsuppose due to any reason it can't fix your problem then use thirdparty excel repair softwarehttp://www.stellarinfo.com/excel-recovery.htm
540 views
Usually answered in minutes!
×