Problem with Refreshing entire excel workbook

I'm trying to refresh a entire excel workbook using Application.CalculateFull function. However, I found that, the sheet does not get not updated ALL the time (s开发者_如何转开发ometimes it do). A random number of functions only get updated at sometimes. I'm using excel 2007, please tell me what's going on with Application.CalculateFull function.

Thank you

---

What happens if you try this line instead?

Application.CalculateFullRebuild