With 1700 columns I think you're in the new format.<g

If calculations are sufficiently complicated or numerous Excel stops trying
to do an intelligent calculation (just the cells that have changed) and
instead just calcs the entire workbook. That's because the time saved in
the calc is less than the time it takes to keep track of dependencies. If
you've reached that point the Calc message is permanent I believe.

--
Jim
"Alan Smith" wrote in message
...
| Hi all,
|
| I am using Excel 2007, and have a large file (11MB) that is giving me
| problems. The file is used to forecast revenue opportunities for a 4 year
| period, and then calculate the recognized revenue based on the timing of
| deals, revenue type etc. and is approxiamately 735 rows by 1700 columns.
|
| Within the worksheet are many formulas, using various combinations of SUM,
| VLOOKUP, SUMPRODUCT, OFFSET, SUBTOTAL, SUMIF, INDEX, COUNTA, MIN and
probably
| a couple more, but there are no errors in the worksheet.
|
| Despite constantly checking the settings (Automatic, no iterations),
and/or
| hitting F9 (which doesn't work, btw), I have a "Calculate" message in the
| status bar. I believe the previous 65536 limits were removed in 2007, so
that
| should not be an issue. Is there something else causing a problem? Any
ideas?
|
| Thanks,
|
| Alan