Changing values in a range does not update the total

  • Thread starter Thread starter Ramneek
  • Start date Start date
R

Ramneek

Hi

This one is strange

I have totalled a range of cells. Now when I change a
value in one of the cells in the defined range, the change
is not reflected in the total

Could somebody please help

Thanks in Advance
Ramneek
 
See answer in other group. Please don't multipost.

Regards
Anders Silven
 
Verify in Tools/Options if in the Calculation tab the option Automatic is selected..

LT

----- Ramneek wrote: ----

H

This one is strang

I have totalled a range of cells. Now when I change a
value in one of the cells in the defined range, the change
is not reflected in the tota

Could somebody please hel

Thanks in Advanc
Ramnee
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Values in cell doesn't update the total 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel VBA 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
SUM - but ignoring text in the data range 3
writing a sort macro 2
Paste Special Values 2
Cell not calculating after importing data 2

Back
Top