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."
Getting list of project names from another sheet and keeping static data in line with project names
I want to get Project Names from a dynamic Master List in Excel and put those Project Names on a second worksheet where I can manually enter additional information related to the project, for project management purposes. If a Project is removed from my Master List then it should be removed from my second worksheet. In addition, I need the manually entered on the second sheet to stay aligned with the right project. I've attached a sample copy of my workbook. Thank you in advance for your assistance!Using Excel in Teams vs. the Excel Application
Will it be possible for Excel in Teams to incorporate all capabilities from working within Excel (the actual application) in the near future? Currently not all Excel formatting options are available and not all cell formats are preserved when transferring Excel files into Teams. In particular, not all border types for cells are included in Teams or shown when opening a file in Teams (e.g. the 'slash' border that crosses out a cell).
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
Paste friendly link into Outlook
Desperately hoping for a solution to this! When pasting something from the MS Teams version of Excel into Outlook, my "friendly links" stop working. That is, I have a cell that uses the formula: =hyperlink(link_location, [friendly_name]) When I paste the contents into the body of an outlook email, only the "Friendly Name" text is there, and it is no longer a hyperlink. The hyperlink is retained if I paste from desktop version of Excel into an outlook email, but NOT if I paste from within MS Teams Excel into an outlook email. Does anyone know a workaround for this? Personally I always just open MS Teams Excel in the desktop version of Excel, but I am overseeing other users for whom that additional step is too complicated. Thanks very much!
how to make cells do certain tasks?
I am new to excel and looking for a way to make things automatic. I want to make a table with a yes or no toggle cell and do certain actions like... if no, to apple a strikethrough and fade to text and if yes, to make no changes. can this be done? here is a picture for reference. Thanks in advance.Copying Regular numbers from an excel spreadsheet into a spreadsheet kept in Teams
I'm sure this is user error but it's maddening and I just can't seem to figure it out! I want to copy a column of regular numbers to a spreadsheet I have in excel but when I do, I get a set of numbers depending on what selection I choose (Text, General, Number...) none of which are just a regular number. I have tried every conceivable option and can't get it to just copy a regular number. One thing I was told was to switch both columns before copying to text, then copy and paste. That didn't work for me. Any ideas? Seems like a very odd limitation if it's not possible to transfer regular numbers that's why I'm sure it's something I'm doing or not doing. Thank you for your help!
Excel - Lost data
Hi, I need help to recover the data. I have lost the data by mistake and now I would like to understand if there is a way to recover that data. I have a file (Name - Drive D FY19-20) saved in drive D and have created a desktop shortcut (Name - FY19-20). I have created another copy of that shortcut file (FY19-20) on the desktop and have changed the file name (Name - FY20-21) to begin with the changes. Now whatever changes I have made in the file FY20-21 are reflecting in my original file saved in drive D FY19-20. Therefore we have lost our previous years account. Is there any way to recover the data before changes? Thanks VivekShifts schedule export to Excel has problems ...
If exporting simply (not clicking on "file that can be imported), then Shift notes do not appear as a column. You have to doubt-click the column in Excel with the shift reveal the shift note. Also, even if you uncheck daily hours and time off, it still exports them. If you export with "file that can be imported" you lose cell shading colors (it becomes a column with the color written out) and each employee could have two or three rows if there is a shift note added. Exporting to excel and then dropping into Slack loses spreadsheet presentation and puts each column on its own page. Quite a mess.
