F11 Crashes Excel

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

DownThePaint
Thu Mar 13 20:43:01 CDT 2008

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,

"kirkm" wrote:

> 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
>
>

Dave
Thu Mar 13 21:07:50 CDT 2008

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

kirkm wrote:
>
> 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

--

Dave Peterson