Hi Bob,
About half the time I use Excel,
upon quitting Excel I get a message saying it
has generated a Microsoft error report, asking
if I want to send it to Microsoft so they can
use the data to help fix the problem. This usually
happens in conjunction with Excel telling me "unable
to empty the clipboard" when the clipboard is already
empty. When I close Excel and restart it, this
problem goes away, but not without generating one
of these error reports.
Any ideas how to fix this problem.
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.
Excel 2003 has some new features, which may disable certain files when
Excel thought them to be the cause of a crash.
If you have had a problem with Personal.xls, Excel may have labeled it
as suspect.
In Excel, select Help | About Microsoft Excel.
Click the button near the bottom labeled "Disabled Items..."
If Personal.xls is listed, select it and click Enable.
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 MVP
www.jkp-ads.com