Feedback by UserVoice

jeffrey Weir

My feedback

  1. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  2. 14 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  · 

    Yes please. For Tables too. Meanwhile, here's a link to my workaround code http://dailydoseofexcel.com/archives/2017/12/08/identifying-pivottable-collisions/

  3. 4 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on 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

    jeffrey Weir commented  · 

    By the way, PowerPIvot will let you do this, using a disconnected slicer. https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

    jeffrey Weir supported this idea  · 
    jeffrey Weir commented  · 

    I coded up this very thing in VBA today! Works a treat. Had to use a disconnected slicer, and a 'settings' table that records what aggregations/layout/formatting gets applied.

  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 commented  · 

    You say something has changed. What? Your Cologne? The President?

  6. 640 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

    Thanks,
    Steve (MS Excel)

    jeffrey Weir supported this idea  · 
  7. 406 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

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

    Sure, some people can make some bad design choices. But they can make bad choices with *any* Excel functionality, old or new. For instance, I already see people making Pivots of Pivots. Does that mean that Pivots are a bad idea? No, of course not. It just means that some folk are making bad design choices. Everything in Excel is used badly by somebody.

    I'll give you one example of how I use this: to make non-pivot charts out of PivotTables and have those Charts update dynamically. PivotCharts don't give me anywhere near the level of flexibility I can get from a normal chart. Being able to connect normal charts dynamically to a PivotTable means I can choose which series from a PivotTable I want to display. Or lets me bring data from two different parts of a sheet or workbook together into one chart. I can do a whole heap of tricks from Jon Peltier's website to produce practically any graphic I need. I can pretty much do what I want. Including Scatterplots.

    I can do great charting hacks that simply are not possible with a standard PivotChart.

    jeffrey Weir supported this idea  · 
    jeffrey Weir commented  · 

    Kenneth: Read http://chandoo.org/wp/2014/10/18/introducing-structured-references-for-pivottables/ for examples.

    This suggestion would FINALLY fully integrate PivotTables into formula-driven spreadsheets. GETPIVOTDATA just doesn't cut it, as it can only be used on one cell at a time, and only on cells in the VALUES area.

  9. 3 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  · 

    Great idea.

  10. 44 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 input. We’ll consider this in our future planning efforts. Please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

    jeffrey Weir commented  · 

    Amen. It doesn't make sense to me that we can build pretty sophisticated dashboards in an Excel Sheet with the exception of mapping. Sure, we could use PowerBI or PowerView, but frankly they don't allow anywhere near the level of customization of charts and Pivots as we get in Excel's grid. Allowing us to essentially insert a map as a chart would be a killer feature.

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

    I don't want to spend my last vote on it, but good idea.

  12. 4 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  · 
    jeffrey Weir commented  · 

    Yeah, I'm staggered that you can't do this natively. I wrote some fast workaround code at http://dailydoseofexcel.com/archives/2013/11/14/filtering-pivots-based-on-external-ranges/

  13. 7 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  · 

    How does that differ markedly from your option 2) ?

  14. 228 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 suggestion Nick. We’ve got some related work we’re looking at soon, and we’ll be sure to carefully consider if we can get a fix in for this then. As always, more votes helps – so keep voting for the things you care about most.

    Thanks,
    John [MS XL]

    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 commented  · 

    Sameer: Binary search = sorted data. Can't have one without the other. That said, the binary search implementation should warn you if the item being searched for is not the one you are looking for. Currently it doesn't.

  16. 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  · 
    jeffrey Weir commented  · 

    Amen

  17. 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  · 
    jeffrey Weir commented  · 

    Don't forget text in message boxes too.

  18. 387 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. 239 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 suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    jeffrey Weir supported this idea  · 
    jeffrey Weir commented  · 

    Great idea. Using the current CF manager is like trying to build a ship in a bottle.

  20. 257 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  · 

Feedback and Knowledge Base