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
|