Thank you so much!!!! That was it, I really appreciate your response. Roger

"Nick Hodge" wrote:

Have you got calculation on manual?

ToolsOptions...Calculation check automatic

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"RVsnk77" wrote in message
...
I have an excel file that I've maintained for over two years now, it has
simple formulas that sum different fields. The formulas are not updating
the
way they typically do. For example, if I'm summing column M6 through M12,
the
sum does not update if I change a value within that range. I have to
re-sum
that column, in the past if I changed a value within that range the sum
would
automatically update. I can copy and paste to a new file however then I
then
have to reformat and create a new chart. Help anyone?