Excel will not load

[Mike]

When I try to run Excel, I get the error message "This
program has performed an illegal operartion and will be
shut down. If the problem persists contact the program
vendor.

When I hot the Details button I get, "Excel caused an
invalid page fault in module excel.exe at 0167:30026e31"

In trying to fix this problem, I have reloaded the orginal
Outlook 2000 program. This does not correct the error.

Any ideas?

 

[Jan Karel Pieterse]

Hi,

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 TA/MVP

 

[Jan Karel Pieterse]

Hi,

Sorry, please ignore my previous post, I pasted in the
wrong text.

This is a default list of things-to-do when Excel exhibits
startup problems.

Try opening Excel without any addins or hidden workbooks:

Start, Run,
"C:\Program Files\Microsoft
Office\Office\Excel.exe" /Automation

Quotes mandatory, Note you may have to change the path.

If your error disappears, there is either an add-in or a
(hidden) workbook that is loaded upon XL's start, which
bothers you.

- Try locating the XLSTART directory, move everything from
there.
- In XL: Tools, Addins, note the ones checked and uncheck
them one at the time, each time restarting XL
- In XL, Tools, options, general. Check if a path is
entered after "Alternate startup file location". Clear it.

Another option is to open XL in Safe mode:

"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe

Also, you might try:

"C:\Program Files\Microsoft
Office\Office\Excel.exe" /Regserver

Yet another possible problem is a corruption of your
toolbar customisation file. Locate all files with
extension .xlb and rename the extension(s) to something
like .old
Now try and start XL again.

Also, NAV has shown to cause "Excel caused an invalid page
fault in module VBE6.DLL".
You might try disabling the Office plug in of NAV.

Other causes may be a full TEMP folder:

In Windows 95/98 and ME

Delete all files in C:\Windows\Temp

In Windows NT/2000/XP

Find and Select C:\Documents and Settings\<user>\local
settings\temp
and delete all files in there.

They are often left behind by installing programs but
Excel needs the space.

This is what MS has to say about startup problems:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q280504

And this about startup switches:

http://support.microsoft.com/default.aspx?scid=KB;en-
us;q211481


Regards,

Jan Karel Pieterse
Excel TA/MVP