Forum Discussion

Yuepheng1's avatar
Yuepheng1
Copper Contributor
Jun 15, 2021

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_So's avatar
    Yea_So
    Bronze Contributor
    https://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
  • StoneKiwi's avatar
    StoneKiwi
    Iron Contributor
    It'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.
    • Yuepheng1's avatar
      Yuepheng1
      Copper 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 

      • StoneKiwi's avatar
        StoneKiwi
        Iron Contributor
        Hi,
        Do you mean Microsoft Teams?
        Is the Excel file stored on sharepoint or Onedrive?

Resources