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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies