Excel re-calc problem

[sgreenwood]

I'm having problems with a particular file not wanting to re-calc. It's not a very large file (45 sheets), but it is very formula intensive. The file used to re-calc fine either manually or when set to automatic, but now it won't re-calc either way.

If I save the file, close it, then reopen it I can hit re-calc and the entire worksheet will re-calc fine. After that first re-calc it doesn't work anymore.

There are no macros running in the file to affect anything. The only way I can get the correct values is to actually go to a cell, edit (f2) then press enter...the correct value will then calc.

It's the strangest thing I've ever dealt with. There are so many formulas relying on other cells that the file has become useless to me if I can't trust that it has calced properly.

I'm running Excel 2002 SP-2.

Does anyone have any suggestions at all?

Thanks for any help.

Steve

 

[KenWright]

Is this by any chance your problem:-

http://support.microsoft.com/default.aspx?scid=kb;en-us;243495

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Tiglet]

the only other thing that i can think of is that the raw data has been imported from elsewhere and is not numeric, even though it is formatted as numeric in excel - it's a funny that can cause nightmares!

If the cell that you are having to hit F2 on is raw data, then try taking all the raw data and multiplying it by 1 to guarantee that it is numeric.

(Copy into new sheet, multiply by one, then copy paste special values back into calc sheet)

Tiglet

Living on Earth is expensive, but it does include a free trip around the sun every year

 

[GlennUK]

I've had this happen. Excel refuses to do the required calculations. The only solution I've used in the past is to do an edit/replace ( from string of =, and replace with string of = too - i.e. no change really ). This forces each cell with a formula to be visited by the calculation engine of Excel.

I haven't had this happen in a long time, so can't remember the long term fix for this ( might actually have been redesign of workbook!?!?! ).

Good luck.
Cheers, Glenn.