All formulas return 0

  • Thread starter Thread starter johndoe_
  • Start date Start date
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
 
Your description doesn't quite fit my experience...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convertion formula for (min/mile) to (mile/hr) 3
v07 cell shows formula string literal not value returned from formula 1
Strange formula problem 6
All formulas return a zero value. 1
my formulas return a zero 3
Formatting in formulas not allowed before commas 5
What's Wrong With This Formula? 12
Excel Date Formula Question 9

Back
Top