874 votes141 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
Well anonymous, I might have done, had not 126 previous comments and 800 odd votes demonstrated the futility of that approach...
Presumably there is no progress on this because the Access team have forbidden the Excel team from dealing with this very significant flaw in case it means that Excel can be used for basic database stuff rather than using a proper database.
Would it help speed things up if you were to think of this as correcting a serious bug rather than as an enhancement?
Well said Malcolm. Given the obvious importance that the Excel team are attaching to the Power Query/Get & Transform developments, it does seem strange that they are ignoring an area that is so vital to the whole approach.
Thanks DMT, but I've been doing that for the past 18 months or so...
Hi Ashwini - is there anything else we can do to convice you of the importance and urgency of this requirement?
Add rows to Table on protected sheet
A good starting point would be just to allow rows to be added to Tables when a sheet is protected, with the other cell locking functionality working in Table cells in the same way as non-Table cells. As Jon says in his original proposal, the absolute inability to add a row to a Table on a protected sheet makes it impossible to use cell locking and protection with a Table. Fiddling about with how formulae are created as suggested by anonymous is no solution at all as it does nothing to stop someone deleting or overwriting the formula/range name.
I am sure these things are never as simple as they seem, but an added 'Protect Sheet, Allow all users of this worksheet to:' option to 'Add rows to a Table' would be a substantial step forward.
3 votes2 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
8 votes2 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thanks for the feedback. We are exploring the possibility of adding a time playback axis to all native charts in a future release. Please continue to vote on this feature idea.
Thanks Scott - that's good to hear.Simon Hurst shared this idea ·
92 votes18 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
The grouping could also be useful in applying similar protection to a set of worksheets in one go, rather than having to do so individually, or relying on VB.