link to a cell in an external spreedsheet

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

trying to reference a cell in an external spreadsheet. Can anyone help with
the syntax?
Terry
 
Hi,

If the other workbook is open
=[mybook.xls]Sheet1!$A$1

or if its closed

='C:\mypath\[mybook.xls]Sheet1'!$A$1

Mike
 
Open the sending workbook.
Change to the sheet with the cell
Select that cell
Edit|copy (or ctrl-c)

Swap to the receiving workbook.
Change to the sheet that gets the formula.
edit|paste special|paste link

If you close the sending workbook, you'll see that excel will adjust your
formula.
 
trying to reference a cell in an external spreadsheet. Can anyone help with
the syntax?
Terry
Click to expand...

Terry: Type the = sign, navigate to the cell you want linked, click on
it,and then Enter. Or am I missing something?
Pierre
 

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

Can't save Excel spreadsheets 1
Cell update delay 5
Change number to word 4
Three levels of protection in one worksheet 1
VBA guys needed 1
does any one know to copy cells within an IF statement in Excel 10
Stop cell changing 3
Excel How To Convert Decimal To Inches 2

Back
Top