Questione re: Create an external reference (link) to a cell range in another workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1259836%22%20slang%3D%22en-US%22%3EQuestione%20re%3A%20Create%20an%20external%20reference%20(link)%20to%20a%20cell%20range%20in%20another%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1259836%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%20Sorry%20if%20this%20ends%20up%20being%20a%20duplicate%20post.%26nbsp%3B%20First%20off%2C%20I'm%20not%20a%20strong%20Excel%20user%2C%20but%20I%20am%20starting%20as%20Admin%20for%20our%20Sharepoint%20site.%26nbsp%3B%20One%20of%20my%20teams%20wants%20to%20make%20a%20spreadsheet%20for%20a%20project%2C%20and%20wants%20to%20share%20it%20with%20Clients%20on%20Sharepoint%2C%20but%20with%20some%20columns%20left%20out%2C%20pricing%20data%2C%20private%20contacts%2C%20etc.%26nbsp%3B%20If%20I%20create%20a%20second%20workbook%2C%20and%20have%20it%20pull%20most%20of%20the%20columns%20from%20the%20Teams%20original%20workbook%2C%20will%20that%20update%20as%20they%20make%20changes%20to%20the%20visible%20fields%3F%26nbsp%3B%20We'd%20rather%20not%20make%20copies%20all%20the%20time%2C%20just%20do%20the%20work%20in%20one%20workbook.%26nbsp%3B%20Also%2C%20will%20this%20work%20in%20the%20Sharepoint%20environment%20(pulling%20fields%20from%20a%20different%20workbook%2C%20but%20hosted%20on%20Sharepoint%2C%20in%20a%20parent%20site)%3F%26nbsp%3B%20Thanks%20in%20advance!%26nbsp%3B%20chris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1259836%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello!  Sorry if this ends up being a duplicate post.  First off, I'm not a strong Excel user, but I am starting as Admin for our Sharepoint site.  One of my teams wants to make a spreadsheet for a project, and wants to share it with Clients on Sharepoint, but with some columns left out, pricing data, private contacts, etc.  If I create a second workbook, and have it pull most of the columns from the Teams original workbook, will that update as they make changes to the visible fields?  We'd rather not make copies all the time, just do the work in one workbook.  Also, will this work in the Sharepoint environment (pulling fields from a different workbook, but hosted on Sharepoint, in a parent site)?  Thanks in advance!  chris

0 Replies