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