Forum Discussion
Limitations of Web-Version Office 365 Excel Data Validation
I just need to check with someone else. Does the webversion of 365 lack certain features that are available in Desktop copies of Excel? I'm trying to create a dependent drop-down value, but I keep getting error messages when I try to mess with the formula in data validation to allow it to cascade into lower rows automatically.
Every single tutorial I've seen and read has been for a Desktop version of Excel, so I'm starting to lose hope that it's even possible for me to do it. All I want is a single layer of dependent drop-down that works on every row in a sheet. But getting it to work on every row is just proving impossible.
If there's a way to get the formula that's set-up in B3, to work in every row below, but change the formula to B4 and so on - without moving the cell references for the tables. That'd be terrific. But I don't think its possible on the web version of Excel.
"Does the web version of 365 lack certain features that are available in Desktop copies of Excel?"
Yes it does, but it also has some features that you will not find on the desktop.
I'm not a frequent user of the web version and can't really explain why Data Validation won't allow you to touch the list formula. It insist that you enter $A$3 and doesn't accept A3. Don't know if it's by design or a bug.
But you can set it up on the desktop and then it will work as expected in the web version. Tested it myself and you can even drag the cells with data validation down and A3 will become A4, A5 etc. Seep picture below from the web.
