cell referencing
 

My excel seems to be handling cell referencing correctly. It is keeping the
old value and not updating the cell with new information.

Example

I type 100 into A1. I then type =A1 into say cell B10. At this point B10
shows 100. I then change cell A1, say by typing in 170. Cell B10 continues to
show 100. When I goto B10, press F2 then enter, it updates it to 170. If I go
back to A1 and then change it again to say 45, cell B10 now continues to show
170.

This is also happening at work. And also other people's version of Excel. It
is causing me massive headaches.

Could this be caused by a virus? Has anybody seen this?

cell referencing
 

Your calc mode has been changed to "Manual".

<Tools <Options <Calculation tab,
And check *Automatic*.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Michael" wrote in message
...
My excel seems to be handling cell referencing correctly. It is keeping the
old value and not updating the cell with new information.

Example

I type 100 into A1. I then type =A1 into say cell B10. At this point B10
shows 100. I then change cell A1, say by typing in 170. Cell B10 continues
to
show 100. When I goto B10, press F2 then enter, it updates it to 170. If I
go
back to A1 and then change it again to say 45, cell B10 now continues to
show
170.

This is also happening at work. And also other people's version of Excel. It
is causing me massive headaches.

Could this be caused by a virus? Has anybody seen this?

cell referencing
 

Make sure calculation is set to Automatic.

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"Michael" wrote in message
...
My excel seems to be handling cell referencing correctly. It is keeping
the
old value and not updating the cell with new information.

Example

I type 100 into A1. I then type =A1 into say cell B10. At this point B10
shows 100. I then change cell A1, say by typing in 170. Cell B10 continues
to
show 100. When I goto B10, press F2 then enter, it updates it to 170. If I
go
back to A1 and then change it again to say 45, cell B10 now continues to
show
170.

This is also happening at work. And also other people's version of Excel.
It
is causing me massive headaches.

Could this be caused by a virus? Has anybody seen this?

cell referencing
 

As has been noted - something set your Calculation to Manual. More Info: it
is typical behavior of Excel that if you open a workbook where it is set to
manual, then it remains set to Manual for any other workbooks opened during
that session. This behavior could explain why it seems to extend to other
people's use of Excel: they've all opened a workbook (the one in question?)
and that's causing others to not update automatically either. So this is
going to be a machine by machine fix.

"Michael" wrote:

My excel seems to be handling cell referencing correctly. It is keeping the
old value and not updating the cell with new information.

Example

I type 100 into A1. I then type =A1 into say cell B10. At this point B10
shows 100. I then change cell A1, say by typing in 170. Cell B10 continues to
show 100. When I goto B10, press F2 then enter, it updates it to 170. If I go
back to A1 and then change it again to say 45, cell B10 now continues to show
170.

This is also happening at work. And also other people's version of Excel. It
is causing me massive headaches.

Could this be caused by a virus? Has anybody seen this?