formula's in cells are not calculating

[Guest]

I have developed a large spreadsheet with many basic formula calculations
For some reason the cells are not recalculating when I drag the + or just
adding 3 cells together . I either get 0 or the original cell amount only ,
even though the cells I am adding have different amounts in them . I have
tried tools - options , calculation tab to see if the auto calculation radio
button has been unchecked to no avail . I have tried saving , save as ,
copying to a new worksheet , rebooting , throwing the computer against the
wall !! - also to no avail

 

[Jon Quixley]

Couple of thoughts (though I won't guarentee any of them might work)
1. Do you have more than one version of Excel installed ?
If you do, ensure that only one is running - this has caught me on mor
than one occasion
2. Does this problem only occur with this spreadsheet or with Excel i
general
3. Which version of Excel are you using - I saw this problem with v200
and although we cured it we never worked out what we'd done to cure it

Anyone got any others?

Jo

 

[Guest]

Thank you for your reply

No i have only one version installed - 2003 Office professional
It appears to be only with this spreadsheet , but my colleagues I am working
with have also experienced similar problems . the common thread with all them
also happens with large detailed spreadsheets