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."
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
IF Function in Excel
Hello Everyone! I need a little guidance from you people. I want to use IF Function of Excel but my cell already contain symbol " . What should I do so that my function can work because excel isn't picking two " symbols at a time. Anyone knows who can help me through this? It will be highly appreciated. Thanks.
Not able to update the new Data in to Powerpivot tables
I have added a line of data in to an exiting table, how the same table is not updating in Powerpivot. with the changes or new data. After i remove the relationship with another table and click on "Refresh", it updates it. and again i have to create the relation ship. Is there a way without removing relation ship with another table, can we update the Data
