Freeware to repair an Excel file

carroll99 · #1 May 8, 2009, 04:14 AM

I need freeware to repair an excel file.
Thanks

NeedKarma · May 8, 2009, 04:48 AM

Excel files rarely need "repair" so you're unlikely to find any. What is wrong with the file?
BTW I have soem expertise in finding freeware/open source version of many apps.

carroll99 · May 8, 2009, 04:59 AM

Thanks for the reply
The file loads ok, but any changes take about 30 sec - drag a cell to another location and the hourglass is on the screen for 30 sec. I did an excel "file open/repair" and got the message that the file was repaired - some conditional format data was removed. however, this did not solve the problem.

NeedKarma · May 8, 2009, 05:12 AM

have you tried opening the file on another computer and making some changes there? The issue could be with either your PC or your version of Excel.

carroll99 · May 8, 2009, 08:20 PM

NeedKarma,
Thanks for your help. I finally solved the problem by saving the Excel file as a .SYLK
file and then saving back as an Excel file. I had to do a little format work, but the file
is no longer corrupted and works fine. This "SYLK" solution came from a Microsoft forum.
Carroll

JBeaucaire · May 9, 2009, 11:31 AM

I'm going to guess that perhaps you were experiencing worksheet "bloat" which I've seen occasionally, too. The cause seems to be when formatting and conditional formatting gets applied to entire columns and rows...traveling FAR outside your actual work area on your sheets.

Sometimes, this starts causing the file SIZE to inflate unbelievably, too, further frustrating the matter.

The simple fix, if this is really what is going on and to keep from losing the formatting/conditional formatting you ARE using, is to highlight all the columns outside your work area and click:

EDIT > CLEAR > ALL

Then repeat that with all the rows below your work area.

My wife recently had an issue at her work, a file she used daily had suddenly bloomed up to 15mg in size and was taking forever to do things. We did the trick above and the file size dropped to 72k.

Egads.

carroll99 · May 9, 2009, 07:05 PM

Thanks for your help. For whatever reason, your suggestion didn't help, but thanks for
trying to help.
Carroll

JBeaucaire · May 9, 2009, 11:40 PM

bummer, well, hopefully it will come in handy when it does happen to you.

Lacyjee · Aug 24, 2009, 04:13 AM

If you found problem in accessing your Microsoft Excel Files, than it might be sure that your Excel Files are corrupt and damaged. So for this you are needed to download a Repair Excel File Software. This is a powerful excel file recovery tool which scans your files and than make them error free.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!