Forum Discussion
Solved
Linking cells to another workbook
Hello, I'm need help with connecting cells. 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 doe...
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 , 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.
SergeiBaklan Thank you so much!
Can I do the same quick way to linking workbook instead of cells?
Or do I have to make hyperlink?
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.