Hi Alan,

I'm not sure the 65536 limit is removed if you use an old pre-2007 file.
Try saving it as a "true" 2007 file and re-open. What happens? Please respond here.

"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