EXCELlent readers,

I have a problem similar to a previous poster. I have an xls file (XL2003)
that will not recalculate any formulae anywhere in the file, regardless of
F9, Shift F9, autocalculate status, etc. The only way I can get the formulae
to recalculate is to go to each cell and re-enter the formula. Extending
selections works fine, so I can for instance select the top row on each
worksheet and extend down, and the cells "recalculate" (actually, calculate
the first time for the "new" formulae). This re-entry of the formulae does
not fix the problem - it simply "re"calculates one time. If I change a cell
value (e.g. by F9), dependencies still will not recalculate.

The odd thing is that I am working with a template that seems to recalculate
fine. When I paste certain data into this file (via VB macro), the
calculation capability becomes disabled. So I don't think the error is in the
template, it's either the way I'm pasting the data, or the data itself.

Does anyone have a clue what's going on here? An Excel-savvy coworker says
he's seen the same thing (files get "corrupted") with his earlier version of
XL and his workaround has always been to regenerate the formulae as I'm
doing. But in my case, something in my (VB macro) methodology is breaking the
recalculation capability, so I have to fix how I'm pasting the data. Unless I
know the cause of the problem, I don't know what I need to change.

Please reply if you have any clue about what's going on.

Thanks much!

Hi Astroskibiker,

Check that your code isn't creating circular references. Unless you've got
iterations turned on, they'll stop recalculations dead in their tracks.

Cheers

--
macropod
[MVP - Microsoft Word]


"Astroskibiker" wrote in message
...

EXCELlent readers,

I have a problem similar to a previous poster. I have an xls file (XL2003)
that will not recalculate any formulae anywhere in the file, regardless of
F9, Shift F9, autocalculate status, etc. The only way I can get the
formulae
to recalculate is to go to each cell and re-enter the formula. Extending
selections works fine, so I can for instance select the top row on each
worksheet and extend down, and the cells "recalculate" (actually,
calculate
the first time for the "new" formulae). This re-entry of the formulae does
not fix the problem - it simply "re"calculates one time. If I change a
cell
value (e.g. by F9), dependencies still will not recalculate.

The odd thing is that I am working with a template that seems to
recalculate
fine. When I paste certain data into this file (via VB macro), the
calculation capability becomes disabled. So I don't think the error is in
the
template, it's either the way I'm pasting the data, or the data itself.

Does anyone have a clue what's going on here? An Excel-savvy coworker says
he's seen the same thing (files get "corrupted") with his earlier version
of
XL and his workaround has always been to regenerate the formulae as I'm
doing. But in my case, something in my (VB macro) methodology is breaking
the
recalculation capability, so I have to fix how I'm pasting the data.
Unless I
know the cause of the problem, I don't know what I need to change.

Please reply if you have any clue about what's going on.

Thanks much!

What happens if you go to Tools optionscalculation and click on calc sheet?