Forum Discussion
Drop down list disappeared
Hi - I have set up a spreadsheet with in-cell drop down lists for my workmates to share over Microsoft Teams. When I opened it today I received an error msg about being unable to process data validations (I didn't write the error down unfortunately!) and now there are no drop downs at all, when I select the cell and go into the data validation option on the ribbon, there's no list showing either. They seem to have disappeared?
2 Replies
Hmcf1 Just this week I ran into this same issue with Excel doc's on MS Teams. The down-arrows all worked fine last week, but not this week.
We found a temp work-around by clicking on the "Draw tab", then the "Insert tab" then back the the "
Home tab" and vwalla...all the down-arrows now work. But...you have to do this procedure each time you go into the .xlsx doc.Differences between using a workbook in the browser and in Excel
Excel in Teams is "Excel for the web", it's just embedded in the Teams interface.
Excel for the web looks a lot like the Excel desktop app. However, there are some differences to be aware of. For example, not all file formats are supported, and some features may work differently than the desktop app. This article explains these differences.
Excel formulas in Microsoft Teams
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
