SOLVED
Home

Linking cells to another workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-569827%22%20slang%3D%22en-US%22%3ELinking%20cells%20to%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-569827%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20need%20help%20with%20connecting%20cells.%3C%2FP%3E%3CP%3EI%20have%20cells%20in%20workbook%201%20which%20will%20be%20updated%20once%20in%20a%20while%20and%20I%20want%20to%20see%20those%20cells%20in%20workbook%202.%20I%20tried%20with%20%3Dworkbookname!A1%20but%20it%20doesn%C2%B4t%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWill%20be%20grateful%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-569827%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-569876%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20cells%20to%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-569876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342518%22%20target%3D%22_blank%22%3E%40HeavenS%3C%2FA%3E%26nbsp%3B%2C%20open%20both%20workbooks%2C%20in%20the%20cell%20of%20the%20second%20one%20type%20%3D%20and%20click%20by%20mouse%20on%20the%20cell%20you'd%20like%20to%20link%20in%20the%20first%20workbook.%20That's%20the%20easiest%20way%20to%20generate%20correct%20link.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-569886%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20cells%20to%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-569886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much!%3C%2FP%3E%3CP%3ECan%20I%20do%20the%20same%20quick%20way%20to%20linking%20workbook%20instead%20of%20cells%3F%3C%2FP%3E%3CP%3EOr%20do%20I%20have%20to%20make%20hyperlink%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-569984%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20cells%20to%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-569984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342518%22%20target%3D%22_blank%22%3E%40HeavenS%3C%2FA%3E%26nbsp%3B%2C%20if%20under%20the%20linking%20workbooks%20you%20mean%20to%20create%20the%20link%2C%20clicking%20on%20which%20you%20open%20another%20workbook%20-%20yes%2C%20hyperlink%20or%20on%20the%20ribbon%20Insert-%26gt%3BLink-%26gt%3BInsert%20Link%20and%20follow%20the%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E
HeavenS
New Contributor

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 doesn´t work.

 

Will be grateful for any help!

3 Replies
Solution

@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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies