Are you able to link a cell and formula to a different cell in a differnt file?
D David C. Glasgo Oct 24, 2003 #1 Are you able to link a cell and formula to a different cell in a differnt file?
L Lady Layla Oct 24, 2003 #2 Yes : Are you able to link a cell and formula to a different : cell in a differnt file?
M Michael Bednarek Oct 24, 2003 #3 Are you able to link a cell and formula to a different cell in a differnt file? Click to expand... Try: ='[other workbook.xls]someSheet'!A1
Are you able to link a cell and formula to a different cell in a differnt file? Click to expand... Try: ='[other workbook.xls]someSheet'!A1
D Dave Peterson Oct 24, 2003 #4 I like to open both files. the start typing my formula: = then use the mouse to point at the cell in the other workbook. Excel will do the heavy work of making sure the syntax is correct. Close that other workbook and watch what happens to your formula.
I like to open both files. the start typing my formula: = then use the mouse to point at the cell in the other workbook. Excel will do the heavy work of making sure the syntax is correct. Close that other workbook and watch what happens to your formula.
