F11 Crashes Excel

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

In the spreadsheet I'm developing the F11 key is causing concern,
especially if pressed. (Or, when someone presses it...!)

You either get (after Excel struggles a bit) -

Excel cannot complete this task with available resources. Choose less
data or close other applications.

Or the much worse -

Microsoft Excel has encountered a problem and needs to
close. We are sorry for the inconvenience.

This happens on every computer (tested = 4), not just mine.

I've no idea what F11 is meant to do - but can it be disabled?

Thanks - Kirk
 
Hi Kirk;
Sounds like you need to make sure all of the Office Updates have been
applied to your computer. A lot of times applying the patches will fix
problems like this one.

Thanks,
 
F11 is going to try to build a chart for you.

If you have a giant selection--or a single cell in a giant used worksheet, it
can take quite awhile to build that chart.

Maybe you can kill F11 with a macro in your personal.xls workbook:

Option Explicit
Sub disableF11()
Application.OnKey "{f11}", ""
End Sub

This would toggle it back to normal.

Sub enableF11()
Application.OnKey "{f11}"
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top