1. Since we are collaborating, it would be nice to have the ability to filter the comments for @mentions. This is helpful to make sure that I reply to everything I needed to.




2. The @mention email notifications are not detailed. It should include more information, including the cell identification.




3. Ability to choose if we want to display all comments or just comments for a particular cell.




4. @Mention with an option to require reply from one or more of the individuals in a comment. If no reply, send follow up email notification. Maybe even have the ability for the commenter to set a deadline for reply.

We have a master summary excel spreadsheet which is linked to cells in supporting workbooks. The files are synced locally on my computer but saved on SharePoint. This way, other users make changes to the supporting workbooks using web access. Then, I open the summary excel spreadsheet saved locally and update values to received the new information. Even though the web version does not supporting linking between workbooks, this has worked in the past since all files are synced locally and the master is refreshed using computer app locally. Beginning on Friday 10/18/19, we started receiving an error for each linked workbook saying "Links to ABC.xlsx were not updated because the ABC.xlsx was not recalculated before it was last saved". Once clicking okay, the links do go ahead and populate the new numbers but if you look at the Edit Links box, it says "Warning: Source not recalculated". This isn't true because the source was recalculated and populated. We have checked all our application setting and formula settings are set to Auto-Calculate. We've also been able to duplicate the issue on a completely different computer and OneDrive account so it appears this might be the result of a software security update. The error will go away once the file is opened/saved locally using desktop app, but will persist as long as the most recent revision was made online in the web version.

On me demande mes informations de connexion. Je tente de re-créer un compte microsoft, on me pose un tas de questions, je réponds comme je peux, je paie Office 365 pour Excel et Word (200€ pour un an). Pendant ce temps, Microsoft m'envoie un code, que je mets. Rien ne correspond. Je ne peux pas ouvrir Excel. On me demande un code, que je n'ai pas reçu. J'ai déjà payé. Impossible de se connecter. Le mail est obsolète. Je ne peux répondre à toutes les questions. On va m'envoyer un code. J'ai déjà payé. Le code arrive mais n'est pas reconnu. Je ne peux pas ouvrir Word. On me demande une adresse mail. Celle-ci a déjà été utilisée pour un autre compte (en fait, le mien). Je me connecte avec une autre adresse. Microsolf va m'envoyer un code. J'ai déjà payé.... etc. Bravo !

Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
It is more important to us to be able to have each person apply a local filter than to have the rare AGGREGATE function work correctly.
Thanks!

For SharePoint access, unfortunately with AutoSave turned off, the cached version of Excel is what is opened locally instead of the sharepoinnt version of an Excel Spreadsheet. The only way to sync up to the SharePoint version is to delete the cached version that is stored locally on your machine. But how to do this? It is buried and hidden, you have to go to the Office Upload app and then delete the cached spreadsheet name that is waiting to be uploaded to the SharePoint. Then and only then can one fetch the correct version of the SharePoint Excel spreadsheet. This is terribly confusing and un-obvious for users with SharePoint documents. Please allow one the ability to turn off the cached Excel Spreadsheets, and even better add specific names of spreadsheets which are never to be cached, so that they can't get screwed up between the sharepoint copy and the local copy.

We noticed that Excel desktop application in Teams will automatically refresh and reflect filter changes made by other users who are also using the file at the same time. This makes it frustratingly hard for users to make changes in the same file because each user would loose their spot that they are working on and no one user can keep the filters constant so they only work on the rows that pertain to them.
Overall, the accounting team that I am a part of really like the collaborative-ness of Excel in Teams ... but this is one item that really frustrates us. Thank you.