I have to share workbooks back and forth with multiple people at my company, so rather than work on them separately, we have been sharing them with one another on one drive. However, we are working off of several different workbooks and one combined master workbook. I have tried a couple of different ways to workbook link, but they don't seem to work in Excel for the web.
Methods tried:
Copy from Source and Paste Link in Destination
"=" in destination, select source data, enter
I don't think VLOOKUP or XLOOKUP would be viable options for what I am trying to do...please help, because we have a lot of data to overlap, and I'm not sure what to try next.
