Unrecognizable text--I NEED HELP PLEASE!!!!

jonchristopher

New Member
Joined
Oct 7, 2002
Messages
3
I need help with an excel file. I have been working and saving information to a spreadsheet on my ibook now for at least 6 months.

I was using the application when my son came in and wanted me to let him play a game. I started the game from my hard drive and it froze up, so I did a soft restart on the machine and when it came back to life my excel data was still on the desktop. However, when I tried to open it I got a message that said it was in an unrecognizable format, but that I could still open it and when I did all I got was a bunch of jumbled letters and symbols. The file says it is 52 Kb in size, so it looks like the data is still there, but I cannot retrieve it properly. Any ideas?

Chris
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
On excel 2002 anyway, there is an auto back up that may have been running...What version of Excel are you running?
 

jonchristopher

New Member
Joined
Oct 7, 2002
Messages
3

ADVERTISEMENT

If I was smart enought to make a backup, then I wouldn't have to come here begging for help.

Thanks
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi

I'm back again...see the discussion on the following with some similar problems

threadhttp://216.92.17.166/board/viewtopic.php?topic=20018&forum=2

maybe there are some others have some other suggestions...


good luck
pll
 

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
My first action would be to select all, and set another font.

Nowadays, the hard drives are so huge, that saving multiple copies (simply add 001, 002, 003 as name suffix) greatly helps in recovering a file.

Perhaps I overdo it; At one time I had the last 1000 saves of a workbook that undergoes repeated revision.

It is a great way to 'backtrack' if the latest code doesn't work, and I can't recall what I need to undo.
This message was edited by stevebausch on 2002-10-08 23:16
 

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Jonchristopher

I found an early post back in Dec 2000 that has to with restoring unreadable data...unfortunely does not bring your formulars accross...


"The following procedure works, but not in 100% of the cases...and it will not recover the formulas - formulas will be pasted as values. You'll have to rebuild the formulas.

If you know the exact path and filename of the xls file, do the following:

(1)Open Excel and start a new workbook (file, new).
(2) Move your mouse pointer to cell A1
(3) In the formula bar, type the following, replacing C:MyDocuments[bad file.xls] with the exact path and file name for the unreadable file. replace Sheet1 with the name of the first sheet.

=+'C:MyDocuments[bad file.xls]Sheet1'!A1

(4) Copy the formula from A1 to every cell where you think you have data. Be careful not to copy to the entire wookbook, as this will take a long time or it may crash.

(5) If the formulas work, range select all the formulas, copy to the clipboard and then from the menu bar, select: edit, paste special, values. The cells will all become values - no formulas.

If you have multiple sheets in the workbook, you will need to repeat this procedure for each sheet, changing Sheet1 with the actual sheet name.

If you have objects from the drawing tools, these will not be recovered - only cell contents.

If you have formatted cells, the formatting will not be recovered.

There are probably some other things that won't recover, but the most important parts - your data will be intact. If you have lots of formulas, this may not be the best solution.

This will not cause any damage to your original unreadable file

Also, if the file is on a network, try opening the file on another workstation. I'm sure you've tried just about anything"


Hope this might help
Good luck!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,822
Messages
5,598,307
Members
414,224
Latest member
Crazy_FC

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top