Home

VLOOKUP data refresh

%3CLINGO-SUB%20id%3D%22lingo-sub-1079118%22%20slang%3D%22en-US%22%3EVLOOKUP%20data%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1079118%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20and%20store%20in%20SharePoint%202%20Excel%20files.%26nbsp%3B%20File%201%20contains%20all%20address%20records%20for%20an%20organization.%20File%202%20contains%2C%20via%20VLOOKUP%20from%20File%201%2C%20a%20limited%20amount%20of%20the%20address%20records%20for%20the%20same%20organization%20(because%20it%20is%20viewed%20by%20a%20wider%20audience%20and%20needs%20to%20be%20a%20bit%20more%20restrictive).%26nbsp%3B%20I%20gave%20the%20client%20access%20to%20both%20files%20and%20they%20update%20address%20information%20in%20File%201%20regularly.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20have%20any%20address%20updates%20transfer%20to%20File%202%2C%20does%20the%20client%20need%20to%20have%20both%20files%20open%20at%20the%20same%20time%20when%20making%20address%20updates%2C%20so%20that%20File%202%20is%20up-to-date%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1079118%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1079579%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20data%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1079579%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F497254%22%20target%3D%22_blank%22%3E%40dcarico%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20write%20that%20the%20client%20is%20%3CSTRONG%3E%3CEM%3Eupdating%3C%2FEM%3E%3C%2FSTRONG%3E%20records%20in%20File%201%2C%20which%20I'm%20taking%20to%20mean%2C%20%3CSTRONG%3E%3CEM%3Emaking%20changes%20to%20existing%20records%2C%20%3C%2FEM%3E%3C%2FSTRONG%3Eas%20opposed%20to%3CSTRONG%3E%3CEM%3E%20adding%20new%20records.%20%3C%2FEM%3E%3C%2FSTRONG%3EIf%20that's%20a%20correct%20interpretation%2C%20then%20they%20(or%20somebody%20else)%20should%20get%20a%20message%20when%20opening%20File%202%2C%20that%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F163032i4000182BC64DF805%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3EThey%20just%20need%20to%20answer%20%22Update%22%20and%20the%20VLOOKUP%20formulas%20in%20File%202%20will%20get%20the%20updated%20information%20from%20File%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EIf%20in%20fact%20they're%20%3CSTRONG%3Eadding%3C%2FSTRONG%3E%20altogether%20new%20address%20records%3C%2FEM%3E%20then%20you%20might%20need%20to%20change%20the%20range%20of%20the%20cells%20in%20File%202%20to%20make%20sure%20that%20range%20is%20large%20enough%20to%20accommodate%20the%20new%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20I%20am%20speaking%20from%20experience%20with%20Excel.%20Never%20used%20SharePoint%20though%2C%20so%20if%20it%20introduces%20some%20different%20processes%2C%20what%20I%20have%20written%20might%20not%20be%20complete.%3C%2FP%3E%3C%2FLINGO-BODY%3E
dcarico
Visitor

I created and store in SharePoint 2 Excel files.  File 1 contains all address records for an organization. File 2 contains, via VLOOKUP from File 1, a limited amount of the address records for the same organization (because it is viewed by a wider audience and needs to be a bit more restrictive).  I gave the client access to both files and they update address information in File 1 regularly.  

 

To have any address updates transfer to File 2, does the client need to have both files open at the same time when making address updates, so that File 2 is up-to-date?  

 

 

1 Reply
Highlighted

@dcarico 

 

You write that the client is updating records in File 1, which I'm taking to mean, making changes to existing records, as opposed to adding new records. If that's a correct interpretation, then they (or somebody else) should get a message when opening File 2, that looks like this:

clipboard_image_0.pngThey just need to answer "Update" and the VLOOKUP formulas in File 2 will get the updated information from File 1.

 

If in fact they're adding altogether new address records then you might need to change the range of the cells in File 2 to make sure that range is large enough to accommodate the new data.

 

P.S. I am speaking from experience with Excel. Never used SharePoint though, so if it introduces some different processes, what I have written might not be complete.

Related Conversations
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
pull data based on dropdown list
bbombb in Excel on
1 Replies