![]() |
|
#1
|
|||
|
|||
![]()
RESTORE CORRUPT FILE
I would try these steps, in the order presented. Each has been used here many times. Sometimes they work, sometimes they don't. NOTE: ALWAYS USE THESE STEPS ON A COPY OF YOUR WORKBOOK, NOT THE ORIGINAL. If something goes wrong you haven't lost the original. #1 My favorite first attempt is to use this free program. It's safe, I've used it many times when downloaded straight from the author : https://excelfilecleaner.codeplex.co...ses/view/85025 ================================================== =============================== #2 https://support.office.com/en-us/art...A-801DDCD4EA53 ================================================== =============================== #3 If you're having a problem with an Excel file, save it as HTML (which is one of the file types in Excel), then save it back to .xls They say that will often recover lost information, or restore a corrupt file. ================================================== =============================== #4 Another way of restoring broken/corrupted Excel files I've been quite lucky actually opening corrupted files in OpenOffice, saving them, and then re-opening them in Excel. Sometimes the formatting will be a little off, but the data is almost always recovered, as well as most of the formatting. Unfortunately, not all of the formula and charts are, but when it happened I was happy anything was salvaged at all. ================================================== ================================ #5 http://directory.s2services.com/excel.htm ================================================== ================================ . |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
Getting the clipboard value: Dataobject error | arjfca | Word VBA | 0 | 12-04-2014 01:51 AM |
![]() |
tanababa | Excel | 2 | 06-07-2012 03:11 PM |
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
![]() |
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |