> This is the same problem I have! I fill the formulae via VBA, but in excel
> 97 they don't calculate, though the formula is correct in each cell.
> 
> How to get round this in VBA?
> > Has anyone encounterd the above problem, if so, how does one PROACTIVELY
> > fix the above problem?
> >
> > The REACTIVE remedy we have come-up with is to:
> > (1) go to the cells not recalculating hit the F2 key and ENTER, or
> > (2) copy and paste the cell (or entire worksheet) that is not
> > recalculating.
> >
> > Is there a way to kill this problem?  Thanks for any info.
> >
> > - Luis Guardia
> > lguardia@npr.org



I know this is ugly, and I'm sure there's a better way, you can do a
Edit Replace for all '=' and replace with '='.  This will force excel to
recalc.

Hope it helps

- Stu Nielsen