Recalculation of formulae disabled

G

Guest

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!
 
M

macropod

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
 

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

Top