Uh oh....cells not calculating

[RAF1112]

HELP!!

I am desiging a worksheet for work....it is a little less than 1MB in size. However, when I update values, some cells are not recalcing. Options are set to Autocalc and even when I hit F9, the values do not update properly. Any ideas?

Thanks!

 

[Chitosunday]

Try pressing ctrl alt f9

 

[RAF1112]

Thanks. What exactly does that do?

 

[Chitosunday]

100% recalculation.

 

[RAF1112]

Thanks so much!

I have a basic print macro (push button) that I will add the 100% recalc to before printing....that may take some time though! HAHA