hitting f9 doesn't calculate all cells 1

[Chrissirhc]

Hi,

Why does this happen you hit f9 or shift f9 or ctrl alt f9 and some cells don't calculate (note these are UDFs) and then when I f2 enter it calculates.

Is the calc tree messed up?

I'm currently going through the sheet replacing = with = to see if that helps...

 

[Chrissirhc]

replacing = with = worked...

 

[Chrissirhc]

Presumably because it marks all cells for recaluation...

Full calc should calc them all anyway, so not sure why it was necessary. Any ideas?

 

[PHV]

Are the UDFs volatile ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[xlbo]

ie do you have

Application.Volatile

as the 1st line in the UDfs ? If not, they will only recalc when a dependancy is changed. If you have that line in, they should recalc on F9 (AFAIK)

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

 

[Chrissirhc]

Ok I understand thanks. Replacing = with = resolved the issue is that because the calc tree was rebuilt? Furthermore, should I expect speed increases because of this? Because the sheet does seem faster...

Thanks,

Chris

 

[xlbo]

would expect slower calc times with App Volatile functions as more things are recalced at the same time......

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

 

[Chrissirhc]

I did it again. I replaced = with = and after one full calc I got significantly faster sheet by sheet calc times. Its like the calc tree was so messed up that it was calculating things that it didn't need to. When I do shift f9 calcs on worksheets the results come back very quickly...

Do you think the reason is because the calc tree was messed up before?

 

[xlbo]

without seeing the spreadsheet with all its calcs and the udfs, it is very hard for me to say one way or the other - certainly sounds like a possibility though

Do you get the same results if you use CTRL+SHIFT+ALT +F9 (complete recalc) and then do sheet recalcs ?

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