Ctrl+Alt+F9 not performing Full Recalculation on some PCs

G

Guest

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
 
C

Charles Williams

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
 
N

Niek Otten

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

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

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top