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?