Excel.exe has generated errors and will be closed by windows.

  • Thread starter Thread starter Ashwini
  • Start date Start date
A

Ashwini

Hi!
I m facing problem while opening a worksheet in Excel
2000 . Size of the worksheet is 2.80MB. When I open the
worksheet follwing error comes on the screen.
"Excel.exe has generated errors and will be closed by
windows.You will need to restart the program."

Please give a solution for the above problem ASAP. File
very critical.

Thanx & Regards
Ashwini
 
Hi Ashwini,
I m facing problem while opening a worksheet in Excel
2000 . Size of the worksheet is 2.80MB.
Click to expand...

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.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top