Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell External Link in a sheet | Excel Discussion (Misc queries) | |||
How do I use a cell value as the filename in an external link? | Excel Discussion (Misc queries) | |||
How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
How can I link a cell to an external photo? | New Users to Excel | |||
External link using calculated cell value | Excel Worksheet Functions |