Hi User,

1. I have total of 11 excel files where I have copied those excel files in Microsoft Teams by creating a Group.
2. Now I need to make a Master sheet where I need to fetch the value from 11 excel files. Those 11 excel files are sync to One Drive Folder
3. I used Vlookup formula and lookup the data from those 11 files.
4. Now when I closed the Master file and reopened it. The link got broken and getting #REF error.

5. How to overcome this issue. My intention is I need to get a Master Summary from all the 11 excel files. Those 11 excel files and the Master file summary both in One Drive only

6. Moreover I want to upload the Master Summary in Microsoft Teams where the data should be shown as per the 11 lookup files.

Kindly help