thanks...do i need to do that for each tab or just once for the whole file?
what causes that problem in the first place? thanks!!!

"Niek Otten" wrote:

> Try rebuilding the dependency-tree with CTRL+ALT+SHIFT+F9
>
> --
> Kind regards,
>
> Niek Otten
>
> "Curt" <Curt@discussions.microsoft.com> wrote in message
> news:DA9B7553-27C1-4C29-B96A-B9E136DFF66E@microsoft.com...
> >i have a large workbook with several tabs and many formulas. For some
> > reason, even though auto-calc is turned on it will not recalc cell
> > formulas
> > when i change inputs. I have to go to each affected cell, edit the cell
> > and
> > hit enter to update the value. it is not a problem for =sum formulas,
> > just
> > those returning a single value from another cell. Anyone experienced this
> > before?
>
>
>