Works exactly the same in 2007

But............you may have two instances of Excel running with a workbook
open in each.

These will not communicate with each other and you can only copy values.

Close the one workbook and that instance of Excel.

Open both workbooks in the same instance/session.


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 11:12:05 -0800, 5T4fr33d0m
wrote:

When ever I do this the value does not stay constant. I think a better way
of explaining my problem is to tell you how I use to do what I want to do in
excel 2003.

I have a summary sheet that adds up all the monthly project expenses which
are entered on another work sheet. Sometimes another worksheet in a
different workbook. I would click on the "destination" cell 1)type the sign
= 2) then I would just click on the source cell within the same sheet, or
worksheet of same file or cell in a whole different work book.

So when ever I added hours of time on one worksheet it would update the
summary expense sheet. There's got to be a simple way of doing this.
Everytime all the cells below the updated cell change or act as if I want
them to copy a range of numbers. Please help - I got to get this new project
summary expense workbook to work.
Thanks!

"NDBC" wrote:

Say the first cell is A1 and the second cell is D1. In D1 type =A1.



"b46ygurl" wrote:

Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other?