Have links to teams files hyperlink from inside teams
If you set up an excel sheet inside of Teams and use it as a index for other documents, using the copy link functionality. Then the excel sheet will not allow you to click on the hyperlinks while inside teams. It needs to be exported out of Teams and then the links work as designed. I believe you should be able to click these links while the document is open inside of teams.