If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel formula's not updating

Polonious · 2004-01-16 15:12:59

Guys, have this problem with Excel XP. I have a few formulas for adding up groups of cells, however when I change the values in the cells, the total cell doesn't update automatically. Anybody seen this before? It should update once i hit enter or move the cursor to a different cell...

Options

16-01-2004 4:12pm

#1

Polonious

Registered Users Posts: 245 ✭✭

Join Date: December 2002

Posts: 182

Guys, have this problem with Excel XP. I have a few formulas for adding up groups of cells, however when I change the values in the cells, the total cell doesn't update automatically. Anybody seen this before? It should update once i hit enter or move the cursor to a different cell...

0

Comments

Options
#2 16-01-2004 4:19pm
seamus

Registered Users Posts: 68,317 ✭✭✭✭

Join Date: July 2001

Posts: 67070

Post up the formulas here...

0
Options
#3 16-01-2004 4:22pm
Mercury_Tilt

Closed Accounts Posts: 5,500 ✭✭✭

Join Date: December 2000

Posts: 5273

This post has been deleted.

0
Options
#4 16-01-2004 4:32pm
Polonious

Registered Users Posts: 245 ✭✭

Join Date: December 2002

Posts: 182

They are just simple Sum formulas, i.e. =SUM(D3:H3)
Thee are a few others too, but nothing complicated.

0
Options
#5 16-01-2004 6:09pm
Mercury_Tilt

Closed Accounts Posts: 5,500 ✭✭✭

Join Date: December 2000

Posts: 5273

This post has been deleted.

0
Options
#6 16-01-2004 6:15pm
Polonious

Registered Users Posts: 245 ✭✭

Join Date: December 2002

Posts: 182

Turns out you were right, it was set to manual! Thanks Mercury.......

0
Advertisement