Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Fix corrupted Excel xls or xlsx file after recovery


  • Please log in to reply
2 replies to this topic

#1 HerbertLorenz

HerbertLorenz

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:03:50 AM

Posted 18 August 2015 - 07:40 AM

Hi Expert
I formated my D drive but I have done by mistake. So I recover all data using Power Data Recovery  many file working ok but some Excel file corrupted and unable to open. How can I fix it?
Thanks!



BC AdBot (Login to Remove)

 


#2 JacobBrown

JacobBrown

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:03:50 AM

Posted 19 August 2015 - 11:00 AM

First try File | Open ... browse for the file, then click the dropdown triangle on the Open button and choose Open and Repair.  If it prompts, the "Repair" options is better, but if it fails, try again, choosing "Extract".
Then, check the size of the recovered file.  Is it likely all your data is included?  if so, you can try to access the data from the file without opening it by creating an external reference.  In cell A1 of a blank workbook, type a reference to the A1 cell of the corrupted workbook, following this format:
='C:\Folder\Path\[FileName.xlsx]SheeName'!A1
Beyond that, what is the file format?  There may be more options.  Lots of help here: https://community.office365.com/en-us/f/172/t/256362

 

 



#3 HerbertLorenz

HerbertLorenz
  • Topic Starter

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:03:50 AM

Posted 19 August 2015 - 11:11 AM

Hi, Thank you for your time and great help. I really appreciate your feedback and I am very thankful for your time and support. My issue solved.

Many thanks.
 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users