Thanks! I had installed it on my home comp and it worked fine there. So
when it didn't work for me at work...lol

"Roger Govier" wrote:


Round Office buttonExcel optionsFormulasWorkbook Calculationtick
Automatic

--
Regards

Roger Govier


"Harlan Grove" wrote in message
oups.com...
xanthippe09 wrote...
I just got set up with Office 2007. I was creating some spreadsheets
and found that I can't just copy formulas over. I fill in a sum
formula, and then drag the content over and it changes the cell range
okay, but it doesn't update the amount. Also, if I change the numbers
within the formula it doesn't update the total. Is there something
I've done wrong?

Press [F9] to see if that produces the correct results. If it does,
your problem is that Excel is set for manual recalculation. And, very
unfortunately, that means you have to wade through Excel 2007's much
less efficient Options dialog. I don't have Excel 2007, so I can't
give you the steps to follow, but you should be able to find out using
Excel online help, searching for the term Calculation.