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
精彩评论