If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
link to a cell in an external spreedsheet
trying to reference a cell in an external spreadsheet. Can anyone help with
the syntax? Terry |
#2
|
|||
|
|||
link to a cell in an external spreedsheet
Hi,
If the other workbook is open =[mybook.xls]Sheet1!$A$1 or if its closed ='C:\mypath\[mybook.xls]Sheet1'!$A$1 Mike "Terry" wrote: trying to reference a cell in an external spreadsheet. Can anyone help with the syntax? Terry |
#3
|
|||
|
|||
link to a cell in an external spreedsheet
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. Terry wrote: trying to reference a cell in an external spreadsheet. Can anyone help with the syntax? Terry -- Dave Peterson |
#4
|
|||
|
|||
link to a cell in an external spreedsheet
On Aug 7, 2:59*pm, Terry wrote:
trying to reference a cell in an external spreadsheet. Can anyone help with the syntax? Terry Terry: Type the = sign, navigate to the cell you want linked, click on it,and then Enter. Or am I missing something? Pierre |
Thread Tools | |
Display Modes | |
|
|