Microsoft Excel Question:
Download Job Interview Questions and Answers 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?
Answer:
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.
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 Question | Next 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? |