Hi,

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

When I start excel, excel refuse to calculate any formula at all. If I
for example enter =today() in a cell, it just returns 00/00/1900. Also
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 that
=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!


--
johndoe_
------------------------------------------------------------------------
johndoe_'s Profile: http://www.excelforum.com/member.php...o&userid=36572
View this thread: http://www.excelforum.com/showthread...hreadid=563185

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

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

johndoe_ wrote:

Hi,

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

When I start excel, excel refuse to calculate any formula at all. If I
for example enter =today() in a cell, it just returns 00/00/1900. Also
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 that
=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!

--
johndoe_
------------------------------------------------------------------------
johndoe_'s Profile: http://www.excelforum.com/member.php...o&userid=36572
View this thread: http://www.excelforum.com/showthread...hreadid=563185

--

Dave Peterson