Microsoft Excel Question:
Download Questions PDF

When I try to open XL, it freezes and all I can do is reboot
* Excel crashes on me regularly, what can I do
* EXCEL caused an invalid page fault...
* Illegal Operation Error when starting Excel?


To-Do List:
Try opening Excel without any addins or hidden workbooks:

1. On the Windows taskbar, click the Start button
2. Choose Run
3. Type "C:Program FilesMicrosoft OfficeOfficeExcel.Exe" /Automation (include the quotes) -- adapt to fit your path.

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

* 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 FilesMicrosoft OfficeOfficeExcel.exe" /Safe

Also, you might try:
"C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver

Another possible problem is a corruption of your toolbar customisation file:

* Locate all files with extension .xlb
* Rename the extension(s) to something like .old
* Now try and start XL again.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
How do I lock in my Title Row and keep it visible while I scroll down to see the rest of my data?Excel crashes on opening / closing / prompts not enough resources?