Feedback by UserVoice

jeffrey Weir

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir shared this idea  · 
  2. 152 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  3. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir commented  · 

    Agreed. Has anyone *ever* met a PivotTable user that put as many fields into the Filters, Rows, and Columns pain as they did into the Values pane?

    All that space wasted, and here's me trying to do the PivotTable equivalent of building a ship in a bottle...

    jeffrey Weir supported this idea  · 
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir shared this idea  · 
  5. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir commented  · 

    Agreed. Something is wrong when power users are constantly hitting F12 and saving a new version, because they are scared the app will bite them.

    jeffrey Weir supported this idea  · 
  6. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir commented  · 

    @Wyn Hopkins: Yeah, that too!

    jeffrey Weir shared this idea  · 
  7. 180 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  8. 547 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  9. 932 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    jeffrey Weir commented  · 

    Agree with the comment below...the lack of any response on this thread (and generally across this forum) is VERY disappointing compared to the kind of engagement we see from PMs over at the PowerBI Ideas forum. Charles Sterling is rightly proud of the level of engagement his team provides over at PowerBI Ideas. The silence here is just deafening by comparison.

    jeffrey Weir commented  · 

    @Alexis Taylor I published another ugly workaround at http://dailydoseofexcel.com/archives/2017/12/10/seven-steps-to-almost-protected-calculated-columns/

    But best bet is to lobby people to vote on this, and lobby bloggers to blog about the glaring hole in functionality.

    jeffrey Weir commented  · 

    How much more interest do you need to prioritize this, Ashvini? There's plenty of votes, other functionality depends on Tables, and users need to be protected from inadvertently breaking mission-critical spreadsheets.

    jeffrey Weir commented  · 

    I've posted a work-around at http://dailydoseofexcel.com/archives/2017/12/10/seven-steps-to-almost-protected-calculated-columns/ that gives you a way to leave the calculated column unprotected while stopping users from directly selecting the cells in calculated columns with the mouse. This works by parking a locked invisible shape over the column. Users can still select the cells by navigating them using the arrow keys, but are then prohibited by overwriting the formulas via a DV condition. They can still delete the formulas however...although I've got a pop-up DV input message warning them against doing so. Convoluted work-around that mostly works, but no substitute for the kind of usability improvement we would get if MS changed Table protection in line with this thread.

    jeffrey Weir commented  · 

    The thing that annoys me is the apparent bug when you have locked some cells in a Table to protect an important formula, but still want users to be able to use the Insert Row functionality. After locking the sheet, if a user right clicks and chooses the Insert Row option, they see the error message "The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet". But the new row has been inserted (meaning the previous error message is actually completely incorrect), although your important protected formula doesn't get copied down (which completely defeats the purpose of protecting it). This is so obviously a bug - one that I'm positive has been reported to MS - and so I just cannot fathom why it hasn't been fixed. Sure, I could write some VBA to add a custom 'Insert Row' entry to the right click menu, but I try to keep my templates macro-free as much as possible. And I wouldn't need macros if this functionality actually did what it says on the box.

    jeffrey Weir supported this idea  · 
  10. 316 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  11. 979 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  12. 434 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  13. 1,349 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.

    - Urmi [Msft]

    jeffrey Weir supported this idea  · 
  14. 873 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    jeffrey Weir commented  · 

    When did Microsoft introduce the ability to open multiple workbooks? Last century? Because the current functionality embarrassingly points at a mentality stuck in that long-distant era. C'mon MS: plug this historic hole already.

    jeffrey Weir supported this idea  · 
  15. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  16. 1,636 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  17. 38 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir shared this idea  · 
  18. 22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
  19. 2,281 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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)

    jeffrey Weir supported this idea  · 
  20. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    jeffrey Weir supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base