Forum Discussion
Yuepheng1
Jun 15, 2021Copper Contributor
Linking MST Excel Data to Excel Spreadsheet Data
Hello, I want to link data/cell values from an MST Excel File to an Excel App spreadsheet. Is this possible? For clarification, I have teams open and have an excel file opened through there and have a separate file open through the Microsoft Excel Application. I want to link the teams excel data with the excel file. I tried searching for answers online but could not find any. Perhaps there is a way?
5 Replies
- Yea_SoBronze Contributorhttps://answers.microsoft.com/en-us/msteams/forum/msteams_tfb-msteams_file-msteams_suboth/trying-to-connect-to-a-microsoft-teams-shared-file/dd2d7dff-f156-4dff-990e-d075fd5c463e
- StoneKiwiIron ContributorIt's unclear exactly what you are wanting but the simplest way is to open both spreadsheets and then use a cell reference to pull the data from one spreadsheet to another.
- Yuepheng1Copper Contributor
You know how you can upload an excel file into MST? I am trying to link data from that file into a spreadsheet that is opened in the actual excel application. In other words, what you are saying is as if the two separate spreadsheets are both opened through the excel application only. StoneKiwi
- StoneKiwiIron ContributorHi,
Do you mean Microsoft Teams?
Is the Excel file stored on sharepoint or Onedrive?