Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
F11 Crashes Excel
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
F11 Crashes Excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 200 crashes | Excel Discussion (Misc queries) | |||
Excel Crashes on me | Excel Discussion (Misc queries) | |||
Excel XP Crashes | Excel Discussion (Misc queries) | |||
Excel Crashes | Excel Discussion (Misc queries) | |||
Excel 97 crashes | Excel Programming |