Solved how to repair damage excel file

June 6, 2015 at 05:40:07
Specs: Windows 7
dear all,
I have an Excel file its size about 19 MB and it was work properly, suddenly we can't open
this file, and it shows the message "unable to read file" , and even if after several attempts, it open then it is not open Properly.
Note that this file is protected with a password.
Is there a solution for this problem, please ?

best regards.


See More: how to repair damage excel file

Report •


✔ Best Answer
June 15, 2015 at 00:27:24
First of all
visit this source, which might be interesting to you:- http://www.excelforum.com/excel-gen...


How to Repair a
Corrupt XLSX File

1.
Navigate
to the folder containing the XLSX file you want to repair.

2.
Right-click
the file and select “Copy” and then right-click on a blank space
within the folder and select “Paste.” This action generates a backup
copy of the corrupted file.

3.
Open
Microsoft Excel 2007 or later.

4.
Click
the “Office” button in the top left corner of the window and select
“Open.”

5.
Navigate
to the folder containing the copy of the XLSX file you generated previously and
select it by single-clicking its icon.

6.
Click
the arrow located to the right of the “Open” button and select
“Open and Repair.”

7.
Select
“Repair.” If you previously attempted this method and the process
failed, try to extract only the values and formulas by selecting “Extract
Data” instead. Regardless of the method you choose, your data will appear
on the screen within a few seconds if the process completes successfully.



#1
June 6, 2015 at 07:48:53
First thing to try is a Repair:

Click the Office button
Select Open.
Navigate to the location of the corrupt file,
do not double click it, just select/highlight it.
Click on the Open button's dropdown list, It's in lower right had corner.
Select Open And Repair
In the pop-up select Repair.

See if that helps.

MIKE

http://www.skeptic.com/


Report •

#2
June 6, 2015 at 08:26:07
If you have Excel 2007 you might also want to run a Diagnostic:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics

MIKE

http://www.skeptic.com/


Report •

#3
June 6, 2015 at 10:54:17
Is this the same file you had problems with in this thread:

http://www.computing.net/answers/of...

If so, then apparently the Repair solution did not work.
You never got back to us on if it did or not.

You can also try turning off Automatic Calculation:

Click the Microsoft Office button
Click on the Excel Options button to bring up the Excel Options dialog box
Click on the Formula button in the left hand pane
In the Calculation section, at the top, click Manual.
Click OK.

Then, try to open the corrupted file

Another option is to start Excel in Safe Mode,
this will tell you if it is a Macro or Add-In that is
causing the problem.

In the Run dialog box type: Excel /s

Then, try to open the corrupted file.
If this works, then it's an add-in or macro.

You can also try saving the file in a different format
such as HTML, DIF, ODS or SLK

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 7, 2015 at 10:34:32
You can repair your corrupted Excel file manually or SYLK or inbuilt repair tool. Have look to article on http://www.techexpertvision.com/the... to know how to repair corrupted Excel work book using top five methods.

Report •

#5
June 15, 2015 at 00:27:24
✔ Best Answer
First of all
visit this source, which might be interesting to you:- http://www.excelforum.com/excel-gen...


How to Repair a
Corrupt XLSX File

1.
Navigate
to the folder containing the XLSX file you want to repair.

2.
Right-click
the file and select “Copy” and then right-click on a blank space
within the folder and select “Paste.” This action generates a backup
copy of the corrupted file.

3.
Open
Microsoft Excel 2007 or later.

4.
Click
the “Office” button in the top left corner of the window and select
“Open.”

5.
Navigate
to the folder containing the copy of the XLSX file you generated previously and
select it by single-clicking its icon.

6.
Click
the arrow located to the right of the “Open” button and select
“Open and Repair.”

7.
Select
“Repair.” If you previously attempted this method and the process
failed, try to extract only the values and formulas by selecting “Extract
Data” instead. Regardless of the method you choose, your data will appear
on the screen within a few seconds if the process completes successfully.


Report •


Ask Question