cell referencing


G

Guest

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?
 
Ad

Advertisements

R

RagDyeR

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!
=====================================================

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?
 
T

T. Valko

Make sure calculation is set to Automatic.

Tools>Options>Calculation tab>Automatic>OK
 
Ad

Advertisements

G

Guest

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.
 

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

Top