Corrupted Individual! please help me

neilwhite · May 10th, 2002, 02:40 PM

can anybody please help i'm desperate, i have what i now know is a corrupted spreadsheet and i desperatley need to recover it, people have advised of excel recovery programs but i dont have $200 to spare , can any one please, please help me!

Neilchriswhite@hotmail.com

xl · May 10th, 2002, 02:45 PM

Neil,

Get XL2002 and your problems "should" be solved.

Jay Petrulis · May 10th, 2002, 03:20 PM

Hi,

You may be able to open it through StarCalc, the spreadsheet from Sun's StarOffice suite. The software is free, but it takes a long time to download. No guarantees, either. http://www.sun.com

If there are a lot of function calls to Analysis ToolPak functions, it may not open fully (meaning your formulae may be lost or throw errors). Also, you will not be able to save your VBA code.

I have StarOffice, both at home and at work, so I can try to open it. Send it to:

john.petrulis@notes.ntrs.com
jaybpetrulis@yahoo.com

Bye,
Jay

Jack in the UK · May 10th, 2002, 03:46 PM

how do you know its curupt???

Any error messages or waht happening thats the *what*

im lost above as i can see the logic, but we need to look at the facts, i dont suggest BUSTING files open as the might but like a safe the door never fit quite the sane again,

version of excel??

Jay Petrulis · May 10th, 2002, 06:40 PM

Hi All,

Just to let you know, Neil's Excel file couldn't be opened (at least by me) in Excel 97.

StarCalc *did* open the file without a problem, and it appears that no data was lost. StarCalc allows you to save as an Excel format, which I did. I then could open the file without a hitch in Excel.

Although this is an Excel site, I would encourage everyone to give StarOffice a try. I personally like its Word Processing program better than Word (I do zero programming in Word -- used only as an advanced typewriter, so take that FWIW).

StarMath is better than MS Equation, in my opinion, too. Its PowerPoint equivalent is nowhere near as good, and I haven't used its database program.

That said, StarCalc is nowhere what Excel is, and StarOffice is not up to MS Office standards, but it it interesting to use in any event.

Best of all, it's free!

Bye,
Jay

Off-topic: To the poster XL -- you have made three posts to this board, and *all* have been caustic. Here, you recommend that the OP pay USD 300+ for and XP upgrade when he originally mentioned that he didn't want to shell out USD200. This was your nicest post, too.

Please play fair. Not everyone is as fortunate as you. Not everybody knows all there is to know about Excel, as you do it seems.

EDIT: Only one page worksheet of the corrupted file was recovered. The rest were blank. StarCalc doesn't usually drop entire pages. Not the total disaster, as there was some success in the recovery, but definitely not good news.

[ This Message was edited by: Jay Petrulis on 2002-05-11 13:43 ]

Ivan F Moala · May 10th, 2002, 07:55 PM

Quote:

On 2002-05-10 17:40, Jay Petrulis wrote:
Hi All,

Just to let you know, Neil's Excel file couldn't be opened (at least by me) in Excel 97.

StarCalc *did* open the file without a problem, and it appears that no data was lost. StarCalc allows you to save as an Excel format, which I did. I then could open the file without a hitch in Excel.

Although this is an Excel site, I would encourage everyone to give StarOffice a try. I personally like its Word Processing program better than Word (I do zero programming in Word -- used only as an advanced typewriter, so take that FWIW).

StarMath is better than MS Equation, in my opinion, too. Its PowerPoint equivalent is nowhere near as good, and I haven't used its database program.

That said, StarCalc is nowhere what Excel is, and StarOffice is not up to MS Office standards, but it it interesting to use in any event.

Best of all, it's free!

Bye,
Jay

Off-topic: To the poster XL -- you have made three posts to this board, and *all* have been caustic. Here, you recommend that the OP pay USD 300+ for and XP upgrade when he originally mentioned that he didn't want to shell out USD200. This was your nicest post, too.

Please play fair. Not everyone is as fortunate as you. Not everybody knows all there is to know about Excel, as you do it seems.

Jay thanks for the StarOffice info...I have
read of it....will try it out...

Agree with your comments re: Xl posts.

Yogi Anand · May 10th, 2002, 08:39 PM

Just to let you know, Neil's Excel file couldn't be opened (at least by me) in Excel 97.

StarCalc *did* open the file without a problem, and it appears that no data was lost. StarCalc allows you to save as an Excel format, which I did. I then could open the file without a hitch in Excel.

Hi Jay:
Thanks for this really helpful information. I have used StarOffice release 5.1 and 5.2 a little bit. Now, I understand there is version 6.0 -- and I believe it is well on its way to being Open Source. It works in Windows, Linux, and Solaris.

Regards!

Anne Troy · May 11th, 2002, 11:03 PM

Don't know if this helps anyone, or if anyone has ever heard of it.

Excel 97 has a little difficulty in renaming the sheets behind the scenes. It goes a little something like this:

Sheet1 is copied into the same workbook. In the VBE, it's now Sheet11. Sheet11 gets copied and becomes Sheet111. Before you know it, you've got Sheet1111111111111111111, and the bottom line is that E97 can't open it after while. I'm not sure what the exact mix needs to be to create the phenomena because it doesn't happen all the time. Could be code in the file, could be code in the worksheet, could be a service release, I don't know the cause.

Anyway, Lotus 123 and higher versions of Excel don't recognize that particular little problem. If your worksheets are heading toward corruption -- happens a lot with workbooks that have been around a long time -- you can save the file down to Excel 5.0, then save back to 97. 5.0 does not recognize the sheet names when they're like that and it *fixes them*.

Excel 2002 actually fixes the problem for you (among other problems; it's got a pretty good repair thing going on); I've fixed a few myself for people who don't have XP and could not open their files.

So, now I'm figuring I can add StarOffice to the list of proggies that'll fix that problem too. Good deal.

neilwhite · May 12th, 2002, 04:14 AM

Thanks for your help Jay the Starcalc Has retrieved the first sheet of my spreadsheet, which gives me some time!! but if anyone out there can recover a corrupted file in full or has Excel fix or Excel Recovery and would want to do someone a massive favour please get in touch!

Thanks in advance !!!

the corruted one

Anne Troy · May 12th, 2002, 07:40 AM

Well, certainly, Neil, if no one has tried opening with XP, I'll give it a shot!

Dreamboat@TheWordExpert.com

May 10th, 2002, 03:46 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	how do you know its curupt??? Any error messages or waht happening thats the what im lost above as i can see the logic, but we need to look at the facts, i dont suggest BUSTING files open as the might but like a safe the door never fit quite the sane again, version of excel?? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 10th, 2002, 08:39 PM	#7
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Just to let you know, Neil's Excel file couldn't be opened (at least by me) in Excel 97. StarCalc did open the file without a problem, and it appears that no data was lost. StarCalc allows you to save as an Excel format, which I did. I then could open the file without a hitch in Excel. Hi Jay: Thanks for this really helpful information. I have used StarOffice release 5.1 and 5.2 a little bit. Now, I understand there is version 6.0 -- and I believe it is well on its way to being Open Source. It works in Windows, Linux, and Solaris. Regards! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

May 11th, 2002, 11:03 PM	#8
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Don't know if this helps anyone, or if anyone has ever heard of it. Excel 97 has a little difficulty in renaming the sheets behind the scenes. It goes a little something like this: Sheet1 is copied into the same workbook. In the VBE, it's now Sheet11. Sheet11 gets copied and becomes Sheet111. Before you know it, you've got Sheet1111111111111111111, and the bottom line is that E97 can't open it after while. I'm not sure what the exact mix needs to be to create the phenomena because it doesn't happen all the time. Could be code in the file, could be code in the worksheet, could be a service release, I don't know the cause. Anyway, Lotus 123 and higher versions of Excel don't recognize that particular little problem. If your worksheets are heading toward corruption -- happens a lot with workbooks that have been around a long time -- you can save the file down to Excel 5.0, then save back to 97. 5.0 does not recognize the sheet names when they're like that and it fixes them. Excel 2002 actually fixes the problem for you (among other problems; it's got a pretty good repair thing going on); I've fixed a few myself for people who don't have XP and could not open their files. So, now I'm figuring I can add StarOffice to the list of proggies that'll fix that problem too. Good deal. __________________ ~Anne Troy

May 12th, 2002, 07:40 AM	#10
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Well, certainly, Neil, if no one has tried opening with XP, I'll give it a shot! Dreamboat@TheWordExpert.com __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 02:40 PM	#1
neilwhite New Member Join Date: May 2002 Location: london Posts: 5	can anybody please help i'm desperate, i have what i now know is a corrupted spreadsheet and i desperatley need to recover it, people have advised of excel recovery programs but i dont have $200 to spare , can any one please, please help me! Neilchriswhite@hotmail.com

May 10th, 2002, 02:45 PM	#2
xl New Member Join Date: May 2002 Posts: 10	Neil, Get XL2002 and your problems "should" be solved.

May 10th, 2002, 03:20 PM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, You may be able to open it through StarCalc, the spreadsheet from Sun's StarOffice suite. The software is free, but it takes a long time to download. No guarantees, either. http://www.sun.com If there are a lot of function calls to Analysis ToolPak functions, it may not open fully (meaning your formulae may be lost or throw errors). Also, you will not be able to save your VBA code. I have StarOffice, both at home and at work, so I can try to open it. Send it to: john.petrulis@notes.ntrs.com jaybpetrulis@yahoo.com Bye, Jay

May 10th, 2002, 06:40 PM	#5
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi All, Just to let you know, Neil's Excel file couldn't be opened (at least by me) in Excel 97. StarCalc did open the file without a problem, and it appears that no data was lost. StarCalc allows you to save as an Excel format, which I did. I then could open the file without a hitch in Excel. Although this is an Excel site, I would encourage everyone to give StarOffice a try. I personally like its Word Processing program better than Word (I do zero programming in Word -- used only as an advanced typewriter, so take that FWIW). StarMath is better than MS Equation, in my opinion, too. Its PowerPoint equivalent is nowhere near as good, and I haven't used its database program. That said, StarCalc is nowhere what Excel is, and StarOffice is not up to MS Office standards, but it it interesting to use in any event. Best of all, it's free! Bye, Jay Off-topic: To the poster XL -- you have made three posts to this board, and all have been caustic. Here, you recommend that the OP pay USD 300+ for and XP upgrade when he originally mentioned that he didn't want to shell out USD200. This was your nicest post, too. Please play fair. Not everyone is as fortunate as you. Not everybody knows all there is to know about Excel, as you do it seems. EDIT: Only one page worksheet of the corrupted file was recovered. The rest were blank. StarCalc doesn't usually drop entire pages. Not the total disaster, as there was some success in the recovery, but definitely not good news. [ This Message was edited by: Jay Petrulis on 2002-05-11 13:43 ]

May 12th, 2002, 04:14 AM	#9
neilwhite New Member Join Date: May 2002 Location: london Posts: 5	Thanks for your help Jay the Starcalc Has retrieved the first sheet of my spreadsheet, which gives me some time!! but if anyone out there can recover a corrupted file in full or has Excel fix or Excel Recovery and would want to do someone a massive favour please get in touch! Thanks in advance !!! the corruted one