Feedback by UserVoice

jeffrey Weir

My feedback

  1. 97 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  · 
  2. 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  · 
  3. 177 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  · 
  4. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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  · 
  5. 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  · 
  6. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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  · 
  7. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    jeffrey Weir commented  · 

    @Wyn Hopkins: Yeah, that too!

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

    We’ll send you updates on this idea

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. …

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

    We’ll send you updates on this idea

    We are working on enabling connectivity from Excel on the web to Power BI. When this work is completed, a PivotTable that is connected to a Power BI dataset will be fully interactive when displayed in Excel on the web. It won’t matter how the PivotTable was created, whether by Analyze in Excel or in some other way. We look forward to implementing and deploying this capability, but I am not yet able to commit to a delivery date.

    jeffrey Weir supported this idea  · 
  10. 1,422 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

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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  · 
  11. 339 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Guy Hunkin
    Excel Program Manager

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

    We’ll send you updates on this idea

    Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again, and please keep sharing your thoughts!
    Auston [MSFT]

    jeffrey Weir supported this idea  · 
  13. 1,489 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. 1,077 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

    An error occurred while saving the comment
    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. 12 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,868 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

    An error occurred while saving the comment
    jeffrey Weir shared this idea  · 
  18. 30 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. 3,380 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    I’m happy to let you know that we are in the planning stages to make Excel for Windows scroll without jumping to the edge of the cell so you’ll be able to scroll smoothly. We don’t yet have a target date, but wanted to tell you about our plans.

    We appreciate all the votes and comments supporting this suggestion.

    Thanks – Steve K [Excel]

    jeffrey Weir supported this idea  · 
  20. 6 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