T Terry Aug 7, 2008 #1 trying to reference a cell in an external spreadsheet. Can anyone help with the syntax? Terry
M Mike H Aug 7, 2008 #2 Hi, If the other workbook is open =[mybook.xls]Sheet1!$A$1 or if its closed ='C:\mypath\[mybook.xls]Sheet1'!$A$1 Mike
Hi, If the other workbook is open =[mybook.xls]Sheet1!$A$1 or if its closed ='C:\mypath\[mybook.xls]Sheet1'!$A$1 Mike
D Dave Peterson Aug 7, 2008 #3 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.
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.
P Pierre Aug 7, 2008 #4 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
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
