Thread
:
Why are formulas not updating when changing a value in the range?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Nick Hodge
external usenet poster
Posts: 1,173
Why are formulas not updating when changing a value in the range?
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?
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge