Excel Doesn't Add

[Josh]

I have two sheets (call them Sheet1 and Sheet2). Sheet1
contains data that I update regularly (i.e. a cut and
paste exercise). Sheet2 takes the raw data in Sheet1 and
organizes it the way I need.

Right now (and this has never happened to me before), when
I update the data in Sheet1, the cells in Sheet2 do not
automatically updated even though they are direct links to
Sheet1.

I've already checked my settings (Tools-->Options--

Calculations-->Automatic radial button) and this does not

seem to be the problem. I've also restarted my computer
and that did not work either.

Any suggestions?

 

[Guest]

It sounds as if you have 'text' in the cells. (Remember:
it is not unusual for text AND numbers to display
identically.) Instead of cut-N-paste, enter a numerical
value directly into one (or more, if necessary) cell and
see if Sheet2 updates. If it does not, then the data is
being treated as text. How is the cell (all affected
cells) formatted?

Also, with the values CURRENTLY in the cells, create a
formula adding two cells in an unused cell on sheet1. If
you do not get a numerical answer, you've got text
equivalents in the cells.

One last 'test' for text values as opposed to numbers: in
a cell, enter the number 01234 -- do NOT omit the leading
zero. IF the zero is displayed, the cell is formatted for
text! Numerical formatting disregards leading zeros.


GL Hopefully, this will get you on the correct path.

gary b

 

[Guest]

YOU DA MAN!!!!

-----Original Message-----
It sounds as if you have 'text' in the cells. (Remember:
it is not unusual for text AND numbers to display
identically.) Instead of cut-N-paste, enter a numerical
value directly into one (or more, if necessary) cell and
see if Sheet2 updates. If it does not, then the data is
being treated as text. How is the cell (all affected
cells) formatted?

Also, with the values CURRENTLY in the cells, create a
formula adding two cells in an unused cell on sheet1. If
you do not get a numerical answer, you've got text
equivalents in the cells.

One last 'test' for text values as opposed to numbers: in
a cell, enter the number 01234 -- do NOT omit the leading
zero. IF the zero is displayed, the cell is formatted for
text! Numerical formatting disregards leading zeros.


GL Hopefully, this will get you on the correct path.

gary b



.