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?.
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.