All formulas return 0

J

johndoe_

Hi,

I'm using VBA to do some reasearch on a few logs I've got. Frome tim
to time I experience a pretty big problem. The problem is:

When I start excel, excel refuse to calculate any formula at all. If
for example enter =today() in a cell, it just returns 00/00/1900. Als
if I for example enter =10/5 which really should return 2, I get 0.

This makes all my formulas return 0...

The only solution I've found to this is to close the spreadsheet
create a "New Microsoft Excel Worksheet.xls", open it. Test tha
=today() works, and then reopen my original spreadsheet.

The formulas then start working...

What may be the problem? I'm pretty tired of this now

Thanks in advance for any help
 
D

Dave Peterson

Your description doesn't quite fit my experience...

But the next time it happens, try:
Tools|Options|Calculation tab|check automatic.
 
Top