Volatile functions - missing the point??

[Chrissirhc]

Hi,

I have a now() in one cell and a hardcoded date in another. I minus the two cells from each other in a result cell. Each time I calculate the result cell using f2 enter the cell with now() does not calculate. I thought that was the point of it being volatile, it will keep calculating ever time a dependant cell is calculated?

Thanks,

Chris

 

[xlbo]

the NOW() function will should calculate whenever a recalc is triggered

what happens if you press F9 ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

I have a now() in one cell and a hardcoded date in another. I minus the two cells from each other in a result cell. Each time I calculate the result cell using f2 enter the cell with now() does not calculate. I thought that was the point of it being volatile, it will keep calculating ever time a dependant cell is calculated?

It works for me. I have Calculation mode set as Automatic, which is required for this behaviour.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Chrissirhc]

Yes I was missing the point. Thanks... It calculates on F9. So if you were on a different worksheet it is only on f9 or ctrl alt f9 that it would be calculated. So you could speed up calculations by calculating each worksheet individually in the right order.

The problem is if you have two sheets that point to each other or you got the calc order wrong...

This is related to my other post. In a workbook created by someone else how do I find out exactly what sheet is calculated during the calc process i.e. how do I see the calc tree...

Thanks,

Chris

 

[xlbo]

see my reply there - I don't think you can see the calc tree

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question