#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 ngày mới làm 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


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:36 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017