I have cells in workbook 1 which will be updated once in a while and I want to see those cells in workbook 2. I tried with =workbookname!A1 but it doesn´t work.
@HeavenS , open both workbooks, in the cell of the second one type = and click by mouse on the cell you'd like to link in the first workbook. That's the easiest way to generate correct link.
@HeavenS , if under the linking workbooks you mean to create the link, clicking on which you open another workbook - yes, hyperlink or on the ribbon Insert->Link->Insert Link and follow the menu.
1 best response
Accepted Solutions
best response confirmed by
HeavenS (Copper Contributor)
@HeavenS , open both workbooks, in the cell of the second one type = and click by mouse on the cell you'd like to link in the first workbook. That's the easiest way to generate correct link.
