Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ctrl+Alt+F9 not performing Full Recalculation on some PCs
Hello ladies, gentlemen, Harlan, Charles... :)
Here is my calculation problem for today. Not sure if this is the most appropriate subgroup, but it follows logically from my previous posts here, so I thought I'd continue. Exectuive Summary: On PCs at my client, Ctrl+Alt+F9 does not perform a full recalculation as I would have expected. For example, PULL does not recalculate. VBA code of Application.CalculateFull works fine. However, Shift+Ctrl+Alt+F9 DOES perform a full recalculation. The client PCs are using Excel 2003 11.6355.6360 SP1. Full description: I have implemented a linking solution that uses the PULL function. On my laptop (running Excel 2003 11.8012.6568 SP2) and a colleague's laptop, the solution works just dandy. Full recalculations are done with Ctrl+Shift+F9 and everyone is happy. However, I started receiving reports of problems with the worksheets when using the client computers, in that PULLed values were not being updated. I have tracked the problem down to the fact that a full recalculation is not being performed upon Ctrl+Alt+F9. When I run VBA code of Application.CalculateFull, the full recalculation works fine. In addition, Shift+Ctrl+Alt+F9 DOES perform a full recalculation, which is supposed to perform a full recalculation with dependency rebuild. The client machines (two machines tested with similar behaviour) are using Excel 2003 11.6355.6360 SP1. It's not the end of the world if all it means is holding down Shift as well, but it has put a dent in my confidence of the solution. I searched the web but found no reference of Ctrl+Alt+F9 not performing a full recalc for any Excel 2003 version. Any thoughts/advice are appreciated. Thanks, Shawn |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ctrl+Alt+F9 not performing Full Recalculation on some PCs
Dont know why: but why dont you trap ctrl-alt-f9 with a VBA OnKey statement
and redirect it to a VBA Application.CalculateFull? Application.OnKey "^%{F9}", "FullCalc" Sub FullCalc() application.calculatefull end sub Charles "Shawn" wrote in message ... Hello ladies, gentlemen, Harlan, Charles... :) Here is my calculation problem for today. Not sure if this is the most appropriate subgroup, but it follows logically from my previous posts here, so I thought I'd continue. Exectuive Summary: On PCs at my client, Ctrl+Alt+F9 does not perform a full recalculation as I would have expected. For example, PULL does not recalculate. VBA code of Application.CalculateFull works fine. However, Shift+Ctrl+Alt+F9 DOES perform a full recalculation. The client PCs are using Excel 2003 11.6355.6360 SP1. Full description: I have implemented a linking solution that uses the PULL function. On my laptop (running Excel 2003 11.8012.6568 SP2) and a colleague's laptop, the solution works just dandy. Full recalculations are done with Ctrl+Shift+F9 and everyone is happy. However, I started receiving reports of problems with the worksheets when using the client computers, in that PULLed values were not being updated. I have tracked the problem down to the fact that a full recalculation is not being performed upon Ctrl+Alt+F9. When I run VBA code of Application.CalculateFull, the full recalculation works fine. In addition, Shift+Ctrl+Alt+F9 DOES perform a full recalculation, which is supposed to perform a full recalculation with dependency rebuild. The client machines (two machines tested with similar behaviour) are using Excel 2003 11.6355.6360 SP1. It's not the end of the world if all it means is holding down Shift as well, but it has put a dent in my confidence of the solution. I searched the web but found no reference of Ctrl+Alt+F9 not performing a full recalc for any Excel 2003 version. Any thoughts/advice are appreciated. Thanks, Shawn |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ctrl+Alt+F9 not performing Full Recalculation on some PCs
I agree, frustrating not to know why.
But OTOH, this is exactly why CTRL+ALT+SHIFT+F9 was introduced; very, very rarely Excel loses it's grip on the dependency tree and then it has to be rebuilt. -- Kind regards, Niek Otten Microsoft MVP - Excel "Shawn" wrote in message ... | Hello ladies, gentlemen, Harlan, Charles... :) | | Here is my calculation problem for today. Not sure if this is the most | appropriate subgroup, but it follows logically from my previous posts here, | so I thought I'd continue. | | Exectuive Summary: | | On PCs at my client, Ctrl+Alt+F9 does not perform a full recalculation as I | would have expected. For example, PULL does not recalculate. VBA code of | Application.CalculateFull works fine. However, Shift+Ctrl+Alt+F9 DOES | perform a full recalculation. The client PCs are using Excel 2003 | 11.6355.6360 SP1. | | Full description: | | I have implemented a linking solution that uses the PULL function. On my | laptop (running Excel 2003 11.8012.6568 SP2) and a colleague's laptop, the | solution works just dandy. Full recalculations are done with Ctrl+Shift+F9 | and everyone is happy. However, I started receiving reports of problems with | the worksheets when using the client computers, in that PULLed values were | not being updated. I have tracked the problem down to the fact that a full | recalculation is not being performed upon Ctrl+Alt+F9. When I run VBA code | of Application.CalculateFull, the full recalculation works fine. In | addition, Shift+Ctrl+Alt+F9 DOES perform a full recalculation, which is | supposed to perform a full recalculation with dependency rebuild. | | The client machines (two machines tested with similar behaviour) are using | Excel 2003 11.6355.6360 SP1. | | It's not the end of the world if all it means is holding down Shift as well, | but it has put a dent in my confidence of the solution. I searched the web | but found no reference of Ctrl+Alt+F9 not performing a full recalc for any | Excel 2003 version. | | Any thoughts/advice are appreciated. | | Thanks, | Shawn | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ctrl+Alt+F9 not performing Full Recalculation on some PCs
Interesting idea.
However, after having run the OnKey code, it causes an "Argument not optional" error whenever I try Ctrl+Alt+F9 with a different active workbook than the one that has the "FullCalc" logic. Thanks, Shawn P.S. Charles, as of yesterday, I'm a FastExcel customer! It already helped me quickly pinpoint a big bottleneck in someone's workbook. "Charles Williams" wrote: Dont know why: but why dont you trap ctrl-alt-f9 with a VBA OnKey statement and redirect it to a VBA Application.CalculateFull? Application.OnKey "^%{F9}", "FullCalc" Sub FullCalc() application.calculatefull end sub Charles |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ctrl+Alt+F9 not performing Full Recalculation on some PCs
Please ignore my "Argument not optional" response. Adding the file name to
the OnKey statement fixes that. e.g. Application.OnKey "^%{F9}", "'ThisWorkbook.xls'!FullCalc" Thanks, Shawn "Charles Williams" wrote: Dont know why: but why dont you trap ctrl-alt-f9 with a VBA OnKey statement and redirect it to a VBA Application.CalculateFull? Application.OnKey "^%{F9}", "FullCalc" Sub FullCalc() application.calculatefull end sub Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disk is full error | Excel Discussion (Misc queries) | |||
How do I change the end cell (Ctrl end) in a excel spreadsheet? | Excel Worksheet Functions | |||
How to use solver to schedule part time and full time workforce? | Excel Discussion (Misc queries) | |||
how do I display a worksheeet in full screen view | Excel Discussion (Misc queries) | |||
Worksheet won't display full screen | New Users to Excel |