Linking a spreadsheet from Teams to desktop Excel

[MurdochQuill]

Hi,

I was thinking about being slightly more productive and having an excel document on my desktop at work pull data from multiple Teams spreadsheets as a link, these spreadsheets are natively uploaded in Teams, so link may be variable on each upload, unfortunately.

In the case it's variable, could it be made into a static path if it is uploaded to Onedrive or similar, even a network location (not sure if possible on Teams)?

Preferably I would be linking it like "=<url>'[spreadsheet.xlxs]Sheet1'!A1

Anyone got some ideas?

Thanks!

 

[Fraxav]

Hi Murdoch,

I am also interested in this, I hope you don't mind me adding to your question rather then posting a duplicate

This may or may not help you, but files on Teams are hosted on Sharepoint, so it should be fairly easy to link them with an address (not that I know I to do it). However, my solution to variable filenames (and Sharepoint addresses) is to import the data from said Teams workbooks based on a (known) portion of their filename.

Say, for example, that I want to import range B1:B10 from VariableTeamsFilename_FirstRange.xlsx and range B11:B20 from VariableTeamsFilename_SecondRange.xlsx into my open workbook (WorkingFile.xlsx).
I would then just type the easy part of each filename ("FirstRange" and "SecondRange") into cells A1 and B1 of WorkingFile.xlsx, respectively. At this point I would just need a macro to look at the text in A1 and B1 of WorkingFile.xlsx and use it to fetch the custom files in "sharepoint.com/TeamsFolder/Uploads/VariableTeamsFilename_*.xlsx" so that Excel could automatically find the right files and populate the cells below A1 with the data in B1:B10 from VariableTeamsFilename_FirstRange.xlsx, and the cells below B1 with the data in B11:B20 from VariableTeamsFilename_SecondRange.xlsx.

Ideally, this would be done automatically (e.g. having the macro also monitor changes in cells A1 and B1) or semi-automatically (i.e. running the macro manually or creating a button for it inside the spreadsheet).

I hope someone can help us out

 

[MurdochQuill]

I'm thinking about hosting the file in a static network location with a text hyperlink instead, seems a bit backwards but it works, I guess!