how to update all functions on an Excel worksheet

Hello Everybody

I have created some functions in Visual Basic in my Worksheet, and I have many cells whose value is generated using that function. Every time I make changes in the "source" data I have to update the calculation on each cell where the function is involved. I step on the cell, press "F2" and "Enter", the same thing for every cell.
Is there a short way to update all the functions at once in a worksheet?

Regards

Have you got calculation set to manual? Tools > Options > Calculation.

Or press F9 to force calculation.

Try to add this line to in the start of your VBA code in the function:

Application.Voilatile

This makes the function recalculate when Excel recalculates.

If your function takes as arguments the variables it needs (as opposed to it wandering through the sheet to find them, which is terrible practice) then Excel knows (via a dependency tree) when it needs to be recalculated, and will do so automatically if calculation is set to Automatic as StephenR suggested.

The need for Application.Volatile is rare, and overuse in complex functions will make your spreadsheet act like it just finished a big lunch and three beers.

I have checked Tools > Options > Calculation to "Manual" (Previously it was in "Automatic"), and I have included the command "Application.Volatile" in the VBA code. Then all the cells update when pressing F9. But if I only do one of both things (Calculation to "Manual" or Application.Volatile) it does not update.
Anyway, I am happy to have my query solved. Thank you very much for your help.

Regards