Board index » Excel » Ctrl+Alt+F9 not performing Full Recalculation on some PCs

Excel253
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


-

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" <sstackhoTEST@yahooTEST.com>wrote in message



-

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" <sstackhoTEST@yahooTEST.com>wrote in message news:51DEA3A6-14E2-46E6-8698-F9F66D7D08CA@microsoft.com...

| 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

|





-

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:



-

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:



-