Connect two Excel spreadsheets in TEAMS
Dear Community, A month ago I decided to save my huge Excel file in Teams and make it available to my team. So now two dozen of colleagues can insert their entries independently and in parallel. This is very helpful because I can also see who changed what and when. Now I have the problem that certain colleagues have to make double entries (same content in my and another table). Therefore, I would like to connect two Excel files, which must remain separate. To do this, I have copied a cell and pasted it into the other table via "Link Paste". The tables are stored in the same folder on Sharepoint. However, I get an error message, that the link was blocked. Has anyone an idea how to solve this issue? The link looks like follow: ='https://xxxx.sharepoint.com/sites/Project/Shared Documents/[Excelfilename.xlsx]TabName'!$H$149 The following error message appears: "Connection blocked External connections to other workbooks are not allowed."
How can I insert data from a Teams message into an Excel table with Power Automate?
Hello, I am trying to enter text from a Teams message into an Excel sheet with Power Automate. I don't see a message snippet option for teams like I see for Outlook, just the entire body. My Teams message looks like this: Data1 Data2 Data3 And I would like to insert Data1 into Column1, Data2 into Column2, and Data3 into Column3. Is this possible? If so, what script should I use to parse the message?
automatic alerts 3 months before a date in MS Teams Excel
Dear Everyone, In the MS Teams excel I share with my colleagues we track programs that have a start and an end date. I would like to create an automatic alert that is triggered when the end date of a program is three months ahead of the current date (i.e. today). Ideally, this alert would print the content of a pre-defined cell. Is this possible? And if so, can you give me suggestions? Thanks a lot. And sorry if this has been posted already somewhere else. Best, ftabetao
