Hi, Bryan:
Yes,
ToolsOptionsCalculations is set to automatic.

"Bryan Hessey" wrote:


Hi,

did you check that Tools, Options, Calculations was set to Automatic?



Twrchtrwyth Wrote:
I created a spreadsheet in Excel 2003 to track fat, carb, and protein
calories from various foods, then add them up. For a while, it would
change
the total at the bottom of each column automatically. Then it stopped.
Each
column now has to be recalculateds manually (by re-entering the
formula)
every time I enter new data. Also, when I copy the formula, the cell
window
shows the revised formula, but the total at the bottom is the absolute
value
of the cell I was copying from--in other words, suppose the formula for
n36
is =sum(n1:n35) and the total is 235. If I copy it to column p, the
formula
shown is =sum(p1:p35), but the total is still 235. This is tedious and
frustrating. How can I get back to automatic recalculation?
--BTW, there's no problem in the rows, only the columns.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=399693