We help IT Professionals succeed at work.

How do you Import an excel 2007 worksheets from a corrupted workbook into another workbook

shannonds
shannonds asked
on
139 Views
Last Modified: 2014-11-18
Hello All,
I have a corrupt Excel 2007 workbook that can't be repaired or even opened.  I need a few of the worksheets from it imported into another workbook.  Any help would be greatly appreciated.

Thanks...
Comment
Watch Question

Danny ChildIT Manager

Commented:
you can try other spreadsheet packages such as LibreOffice to see if they can open it.
Does your system maintain any backups or Previous Versions?
Has it ever been emailed to anyone, as they would have a copy in their mailbox?

Commented:
When an Excel file is corrupted, then you can try several methods to recover it:
 
1.(Free Method) 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.(Free Method) 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.(Free Method) 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 LibreOffice at http://www.LibreOffice.org. Another free office suite.
 
3.3 KingSoft Spreadsheets at http://www.kingsoftstore.com/office/free-excel. This is a free Windows tool that can open Excel files.

3.4 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.(Free Method) 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.(Non-Free Method) 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/recovery.htm
 
It supports both .xls and .xlsx format. 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!
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.