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 doesn´t work.
Will be grateful for any help!
View best response
@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.
@Sergei Baklan 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.