Hi Denise,

If the formulas don't work, goto Tools/Options/Calculation and check
calculation method. Select Automatic.

Keep also a eye on the statusbar, if calculate appears on the statusbar
means that the sheet has bo ve calculated but the automatic option is not
enabled. You can calc the sheet by pressing <F9.

A last thing to keep in mind is that macros can change the calculation
settings

- Application.Calculation = xlCalculationManual
- Application.Calculation = xlCalculationAutomatic

Sometime this is used to speed up the macro if the sheet/workbook contains a
lot of formulas. If the calculation is not re-enabled by the macro, you will
back in manual calculation.

Wkr,

JP

"Denise" wrote in message
...
Hello
I would like to know why some times my formulas don't work and 5 mins.
after
they do. Do you have an explanation for this problem.
Thank you for your answer.