Forum Discussion

Francisco77's avatar
Francisco77
Copper Contributor
Oct 17, 2023

Data connection between two Sharepoint files

Hi All,

 

I have two excel files stored in Sharepoint. For a column from the first file I need to fetch the data from the second file. I could do this with a Vlookup, but the connection is not very stable, could I do this through another type of data connection in Excel?.

 

Thanks for your help.

Excel
  • SanthoshKunder's avatar
    SanthoshKunder
    Iron Contributor
    Oct 17, 2023
    1. Merge both the files into one with 2 separate tabs.
    2. Consider creating SharePoint lists with a lookup column data type if your excel files are small.
    3. Use MS access and import SharePoint lists as tables
    4. You could use .iqy file extension if your data is stored in a SharePoint list.

Share

Resources