Excel 2007 Not Calcualting

[ExcelChampion]

Made the plunge to XL2007 about a month ago. I have run across an issue twice now. A search of the internet shows that this is a common issue, but I have yet to be able to find a fix.

My workbook is on the more sophisticated side with a lot of formulas. I have the workbook set to manual calculation. Hitting F9 or Shift F9 only calculates 'some' of the cells. I would have to manually enter into edit mode for each individual cell to get those cells to calculate that have not calculated otherwise. I assume MS messed with the calculation hierarchy so that cells that "have not changed" don't calculate. Problem is, I have cells that DO need to calculate but are not.

I've searched this board but I cannot find any posts regarding this. But, as I mentioned, a search of the internet shows this to be a fairly common occurence.

Any solutions/tips/tricks would be appreciated.

Todd

 

[RonB1111]

From Microsoft website: http://office.microsoft.com/en-us/excel-help/excel-shortcut-and-function-keys-HP001111659.aspx

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.


CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.