Excel Cell Linking

  osben 15:18 21 Jan 03
  osben 15:18 21 Jan 03

Can anyone help me with the following?

MS Excel XPPro - Have a cell in one worksheet that has a formula to update it from another cell in same worksheet.

Want to be able to link the contents of that cell into another cell of another file and make the contents of the cell in this file automatically update when I open it up.

I know it is possible but can not seem to do it even after having read the help file on linking cells.

Many thanks

  Southend Steve 15:25 21 Jan 03

Have you tried Tool, Options, Calculation, Update Remote References (ticked)

  VoG™ 15:35 21 Jan 03

The way to refer to a cell in another workbook is as per the following example:


  osben 16:47 21 Jan 03

Have managed to resolve the problem now but thanks anyway for your help.

It was appreciated.


  BRYNIT 16:49 21 Jan 03

Open both excel books go to cell you want the info in and click on it.

Click on auto sum symbol ∑ go to work sheet you want the info from and click on this cell.

At the top you should now see something like =SUM('[Exel book.xls]Sheet1'!$D$8),

Click the tick symbol and it should now have the sum in cell/worksheet you want.

This thread is now locked and can not be replied to.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch