Office 365: Referencing a Different Workbook in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1247308%22%20slang%3D%22en-US%22%3EOffice%20365%3A%20Referencing%20a%20Different%20Workbook%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247308%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20community%2C%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20there's%20a%20way%20to%20create%20a%20formula%20in%20one%20Office%20365%20Excel%20workbook%20that%20references%20a%20cell%20in%20a%20different%20Office%20365%20Excel%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1247308%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1247739%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%3A%20Referencing%20a%20Different%20Workbook%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1247739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F591494%22%20target%3D%22_blank%22%3E%40lizdiluzio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20definitely%20possible.%20I%20do%20it%20all%20the%20time.%20Easiest%20way%20is%20to%20have%20the%20both%20workbooks%20open%2C%20and%20just%20write%20the%20formula%20by%20pointing%20to%20that%20other%20workbook.%20I%20have%20found%20it%20certainly%20works%20most%20cleanly%20if%20any%20related%20files%20are%20kept%20in%20the%20same%20folder%20with%20one%20another...and%20not%20moved%20around.%20There%20are%20ways%20to%20reconnect%20them%20if%20the%20connection%20gets%20broken%2C%20but%20why%20put%20yourself%20to%20that%20aggravation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20just%20give%20it%20a%20try%20on%20a%20one%20or%20two%20formulas%20and%20see%20if%20it%20works%20for%20you.%20You%20can%20then%20make%20the%20references%20more%20extensive.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249404%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%3A%20Referencing%20a%20Different%20Workbook%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249404%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20response!%20I%20know%20it%20can%20be%20done%20in%20regular%20Excel.%20What%20I'm%20asking%20is%20if%20it%20can%20be%20done%20in%20Office%20365.%20I%20haven't%20found%20a%20way%20yet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249423%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%3A%20Referencing%20a%20Different%20Workbook%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249423%22%20slang%3D%22en-US%22%3ESorry.%20I%20think%20of%20my%20own%20Excel%20as%20coming%20to%20my%20computer%20via%20an%20Office%20365%20subscription....so%20I%20wasn't%20aware%20of%20any%20difference.%20But%20are%20you%20referring%20to%20the%20solely%20on-line%20system%3F%20If%20so%2C%20yes%2C%20I%20don't%20know%20about%20that%2C%20but%20it%20wouldn't%20surprise%20me%20that%20it%20would%20be%20limited%20in%20this%20regard.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249469%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%3A%20Referencing%20a%20Different%20Workbook%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F591494%22%20target%3D%22_blank%22%3E%40lizdiluzio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20mean%20Excel%20Online%20(Excel%20Desktop%20is%20also%20part%20of%20Office%20365%2C%20depends%20on%20subscription).%20To%20my%20knowledge%20external%20link%20is%20still%20not%20implemented%2C%20you%20may%20vote%20for%20this%20idea%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-for-the-web%2Fsuggestions%2F10366332-links-between-spreadsheets-in-excel-online%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-for-the-web%2Fsuggestions%2F10366332-links-between-spreadsheets-in-excel-online%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249974%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%3A%20Referencing%20a%20Different%20Workbook%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249974%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%3B%20Yes%2C%20thanks%20for%20helping%20me%20to%20clarify.%20And%2C%20voting%20right%20now!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1249981%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%3A%20Referencing%20a%20Different%20Workbook%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1249981%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%20Ah%20I%20understand%2C%20my%20fault%20for%20being%20confusing.%20I%20was%20referring%20to%20Excel%20Online.%20I%20know%20they%20have%20the%20ability%20in%20Google%20Sheets%20and%20was%20hoping%20it%20was%20possible%20with%20Microsoft.%20Maybe%20one%20day.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi community,

Does anyone know if there's a way to create a formula in one Office 365 Excel workbook that references a cell in a different Office 365 Excel workbook?

6 Replies
Highlighted

@lizdiluzio 

 

It's definitely possible. I do it all the time. Easiest way is to have the both workbooks open, and just write the formula by pointing to that other workbook. I have found it certainly works most cleanly if any related files are kept in the same folder with one another...and not moved around. There are ways to reconnect them if the connection gets broken, but why put yourself to that aggravation.

 

Anyway, just give it a try on a one or two formulas and see if it works for you. You can then make the references more extensive. 

Highlighted

@mathetes 

 

Thanks for your response! I know it can be done in regular Excel. What I'm asking is if it can be done in Office 365. I haven't found a way yet.

Highlighted
Sorry. I think of my own Excel as coming to my computer via an Office 365 subscription....so I wasn't aware of any difference. But are you referring to the solely on-line system? If so, yes, I don't know about that, but it wouldn't surprise me that it would be limited in this regard.
Highlighted

@lizdiluzio 

Perhaps you mean Excel Online (Excel Desktop is also part of Office 365, depends on subscription). To my knowledge external link is still not implemented, you may vote for this idea here https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/10366332-links-between-sprea...

Highlighted

@Sergei Baklan  Yes, thanks for helping me to clarify. And, voting right now!

@mathetes  Ah I understand, my fault for being confusing. I was referring to Excel Online. I know they have the ability in Google Sheets and was hoping it was possible with Microsoft. Maybe one day. 

 

Anyway, thank you for your help!