I'm currently experiencing a problem of cells not updating.

Am working on a suite of interlinked excel workbooks - "calculation" is set to manual - when I hit the F9 key some cells update, some don't.

"Calculate" perminately appears in the status bar

I have gone through all sheets in all workbooks and hit Shift+F9.

Have opened and closed all workbooks in differant orders, and have set Calc to automatic

If I swipe over the formulas in the formula bar and hit F9 it shows a differant values to that appearing in the cell.

Any ideas would be gratefully received.