871 votes140 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Lead Program Manager
hey, OMISSION, that's a big word, how about calling it an OM, nice and short. Meaning code that should have been written to do something that everyone thinks should have been done by now that hasn't been written yet. Hey MS, sort this OM, now.
Also, I think MS are balancing this request against the fact that "Professional" developers writing apps and forms etc will be using a database product or programming language that can do all this. So programmers writing code for mere Excel mortals to be able to do the same with XL are eating their own lunch and MS if they make XL able to do this are eating into their SQL server market. They are a business. That said, I think they should eat it and do this. Oh, and another thing, this forum doesn't seem to work for me in Edge.
I have voted for this and I can't wait for them to do it. However, its bugging me that people are referring to this as a bug. It isn't a bug. A bug is an error or usually unfortunate unforeseen consequence of code. This is an OMISSION. They simply haven't written the code to make tables play nicely with worksheet protection. I agree they should get on and do it, but, it isn't a BUG.
Data validation is a usable stop gap if you have a limited distribution but I don't think its a substitute for what's being asked for here - which is, the ability to add a row to a table on a protected worksheet.
489 votes76 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
2,151 votes509 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!
Eric Patterson (Program Manager – MSFT)
Fair point, it isn't used just as a number cruncher. I notice that many people use Excel as a sort of "Project Management" or "Progress Chasing" tool and work with large text based tables - often brightly coloured. I see them sitting at break out tables in meetings all with colour printouts of these things. Perhaps they should be using Project Management Software? MS is probably wary of making something too capable in that area to be part of O365 as Project Management Software is still pretty pricey - which is why people use Excel for it.....
I understand the frustration with this, but, I also have sympathy with MS not prioritising it. I say this as I think Excel's core mission is to crunch the numbers, and although they certainly do pay attention to how it looks and visual ergonomics there are other programs out there where presentation is a higher priority and perhaps people could consider using those to present work having crunched the numbers in Excel.
29 votes5 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
689 votes195 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.
Steve (MS Excel)