#1   Report Post  
Old October 26th 15, 03:42 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2015
Posts: 2
Default How to get Excel repair?

I have a very large excel 2007 file that will not open correctly lately. The file does eventually open after several minutes. When I make a change it takes about a minute to save. This just started to happen to this file last week. Before that it would open much quicker and changes would save right away. It is saved locally and a copy of the file I saved 3 months ago shows it at 58MB. There are no VB or macros. No added images or external databases. Is there a program (preferably free) that can fix this? It is like 60MB in size.

  #2   Report Post  
Old October 27th 15, 03:50 AM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2015
Posts: 10
Default

Một ngy mới lm việc hiệu quả.
  #3   Report Post  
Old October 27th 15, 04:49 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2015
Posts: 2
Default

Excel keeps a lot of 'extraneous' data in files and it grows over time. If possible try cutting and pasting into a fresh workbook and see if the problem goes away (the 'extra' data will stay with the sheets if you use 'move or copy' at a tab level). NB: this method works through the clipboard so you might find the data set is too large for a single iteration,
Alternatively try 'Fail Save As and use one of the earlier formats such as 2003 .xls (if you get a warning that some formula won't work in earlier formats abort and try a different one, in theory the formulas WILL be saved under compatibility mode and recreated when you come back so if all else fails its worth a shot).
The idea is that the Save As process drops all the 'extras' so once that's done you can go back to the 'normal' format. Depending on the integrity/criticality of the data you might want to do some regression to prove that the new file holds the same information as the old one - count of cells, column totals etc. Even if this does not help, then the only way to try to recover the file using XLS Repair Kit. I am sure that this method is 100% should help. http://www.xls.repair/
  #4   Report Post  
Old October 27th 15, 04:51 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2015
Posts: 2
Default

Take a look at this link also for help
https://social.technet.microsoft.com...me?forum=excel
  #5   Report Post  
Old October 27th 15, 09:55 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2015
Posts: 2
Default

I am grateful for the help! the issue has been resolved.


  #6   Report Post  
Old March 10th 16, 04:18 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2016
Posts: 4
Default

You can go with third party DataRepairTools which provide advanced data repair and recovery software. Using Excel repair of DataRepairTool you can get completed solution for Excel file corruption. To know more and repair Excel file data, download this tool from here- http://www.datarepairtools.com/excel-recovery.html
  #7   Report Post  
Old July 2nd 18, 06:48 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2018
Posts: 1
Default Repairing Excel application in AOL syatem

As I use an AOL laptop, I checked all the specifications and requirements earlier before installing the MS Excel, after some days the application was damaged, as it continuously crashed. I called AOL chat support and discussed the issues and asked for the solution to repair my Excel application. Finally, I got the appropriate help and dealt with the solution.
  #8   Report Post  
Old December 21st 20, 12:17 PM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 26
Default Repair a corrupted workbook

When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesnt start, try using this manual process to recover your workbook:

Click File Open.

Click the location and folder that contains the corrupted workbook.

In the Open dialog box, select the corrupted workbook.

Click the arrow next to the Open button, and then click Open and Repair.

To recover as much of the workbook data as possible, pick Repair.

If Repair isnt able to recover your data, pick Extract Data to extract values and formulas from the workbook.

If neither automatic nor manual repair works, there are some recovery methods that might help salvage your data. You can also take some preventive measures to avoid losing your work by automatically saving a backup copy of your workbook or creating a recovery file from time to time.

Hope this helps. If the issue persists get assistance on https://www.o365cloudexperts.com

Regards,
Jerry


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repair Excel Files. DarColl Excel Discussion (Misc queries) 7 April 18th 15 12:39 PM
how to repair an excel file me[_3_] Excel Discussion (Misc queries) 1 August 25th 07 10:20 PM
How do I repair corrupt Excel tables? emmapeel Excel Discussion (Misc queries) 0 August 9th 06 02:40 PM
How to repair an Excel Installation? [email protected][_2_] Excel Programming 0 March 22nd 06 11:04 AM
excel file repair Jerryfromvisalia Excel Programming 1 August 2nd 05 01:48 PM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017