Chart Linking

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

How can a cell in one workbook be linked to data in another workbook.
Kenneth
 
Hi
try the following:
- open both workbooks
- in the target workbook enter the equatrion sign '='
- now select with your mouse the source cell in the other workbook and
hit ENTER
 
Or copy the source cell, select the target cell, choose Paste Special
from the Edit menu, and select Paste Link.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Many thanks to both Frank and Jon for your responses. Your help is much
appreciated

Regards, Kenneth
 
You must log in or register to reply here.

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

Similar Threads

Linking charts 1
Paste Excel Charts in PowerPoint as Linked Objects 1
Chart Location Impact On Links When Copying To New Workbook 1
Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
XL2007: line chart lines disappear when referenced workbook is not open 1
Cannot combine chart type error with only one chart. 8

Back
Top