Check Tools, Options, Calculation is still set for Automatic



Monty Wrote:
i have a workbook with some basic formula =sum(H6:H33) this was working
fine
until yesterday. This formula will only work now when you click on the
formula bar.

any suggestions welcome

Cheers

Monty


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=392815