If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
corrupted excel 2000 file which is password protected
we are looking for a utility which will allow us to
recover a excel 2000 file multiple sheets and passworded. The file was originally stored on a zip disk and we were not able to open the file because of hardware problems with the zipdisk. We then used norton disk doctor and were able to copy the file from the zipdisk to our 'C' drive. When we now try to open the file with excel, it asks for the password, which it accepts, but then gives the following error message The file is approx 3mb and asks for the password which it accepts but then says 'excel has generated errors and will be closed by windows - you will need to restart the program. An error log is being created.' We have also tried to open the file using Excel XP but this only gives us part of the first sheet. Can anybody make a suggestion. Ezra |
#2
|
|||
|
|||
corrupted excel 2000 file which is password protected
Hi
you may try using OpenOffice (www.openoffice.org). Sometimes OpenOffice is able to deal with corrupted Excel files -- Regards Frank Kabel Frankfurt, Germany Ezra wrote: we are looking for a utility which will allow us to recover a excel 2000 file multiple sheets and passworded. The file was originally stored on a zip disk and we were not able to open the file because of hardware problems with the zipdisk. We then used norton disk doctor and were able to copy the file from the zipdisk to our 'C' drive. When we now try to open the file with excel, it asks for the password, which it accepts, but then gives the following error message The file is approx 3mb and asks for the password which it accepts but then says 'excel has generated errors and will be closed by windows - you will need to restart the program. An error log is being created.' We have also tried to open the file using Excel XP but this only gives us part of the first sheet. Can anybody make a suggestion. Ezra |
#3
|
|||
|
|||
corrupted excel 2000 file which is password protected
Hi Ezra,
we are looking for a utility which will allow us to recover a excel 2000 file multiple sheets and passworded. Options to try and open a corrupt file - Set calculation to manual - open the file, but disable macros (assuming you've set macro security to medium: Tools, Macro, security) - As soon as you've clicked the disable macros button, press control-pageup or control-pagedown, thus changing sheets. If that does not work, try creating a link to the file: ='c:\my documents\[MyFileName.xls]Sheet1'!A1 and copy right and down. This at least gets you the worksheets values. if you don't know the sheet names, enter this: ='C:\PathToFile\[MyFileName.xls]'!A1 and press enter If XL (2000) is able to extract them, it will prompt you for a sheet name. Sometimes the Excel viewer, Word or even Internet explorer (v5) enables you to open the file and copy information out of it. If the file is not protected, maybe you can open it with OpenOffice (www.Openoffice.org). Also, Excel XP can sometimes repair XL files with trouble. Finally, sometimes a corrupt file that still can be opened, can be cured using this method (XL2000 or up): - Open the file - Save-as filetype Webpage - close the file - Open the html file - save-as normal Excel workbook. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#4
|
|||
|
|||
corrupted excel 2000 file which is password protected
Hi Frank,
Sometimes OpenOffice is able to deal with corrupted Excel files It cannot deal with protected Excel files alas. I'd try Excel 2003. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#5
|
|||
|
|||
corrupted excel 2000 file which is password protected
Hi Jan
thanks for the info. Excel 2003: IMHO not really better than Excel 2002 in respect to corrupted files -- Regards Frank Kabel Frankfurt, Germany Jan Karel Pieterse wrote: Hi Frank, Sometimes OpenOffice is able to deal with corrupted Excel files It cannot deal with protected Excel files alas. I'd try Excel 2003. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#6
|
|||
|
|||
corrupted excel 2000 file which is password protected
Hi Frank,
Excel 2003: IMHO not really better than Excel 2002 in respect to corrupted files OK. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Thread Tools | |
Display Modes | |
|
|