5 ms·

Excel desktop and web client are still a mess. One of the more common use cases IMO is nothing more than a table with filtering applied. That DOES NOT WORK wi

Excel desktop and web client are still a mess. One of the more common use cases IMO is nothing more than a table with filtering applied. That DOES NOT WORK with Excel under their Office 365 (now Microsoft 365) offering. Data simply won't match up and can easily be lost upon modification where what you see is NOT what you get. For that single reason I dread M365. *It has been like that for over two years and counting, multiple documents and less than a hundred rows and a handful of users.

Pasorrijer 4y ago
This has not been my experience. Not only does filtering work, but in multi user documents it allows you to select user specific or document specific filters, so each user can filter separately. It's not perfect, but most of the time it feels like magic.
- whynotkeithberg 4y ago
  Yeah this is my experience as well... As much as I love to crap on Microsoft this is the exact opposite of my experience.
prepend 4y ago
I’ve been using excel online since 2020 and have numerous spreadsheets with pretty complex tables, filters and pivots and it works properly. And of course data matches up. It is annoying that not all their features are available in browser, but I still prefer it over Google docs for anything other than lists.
berberous 4y ago
Do you select the range and do Insert—>Table? Using an actual table is much better in Excel and the lack of this confuses me in Sheets but that’s probably just because I’m better trained in Excel.
- GeorgeDewar 4y ago
  I did not know about tables in Excel. Now I do and it may change my life...