Feedback by UserVoice

Tim Graham

My feedback

  1. 20 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  2. 1,021 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to offer this in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex. Old versions of Excel will not support the new behavior, so there would need to be some hybrid approach that will be suitable for old and new versions. Also, named ranges can be dynamic, meaning that the range might change and conditional formatting rules would have to be adjusted when the workbook is calculated. There are lots of cases to consider and deal with properly.

    We’ll continue tracking votes for this suggestion.

    Tim Graham supported this idea  · 
  3. 18 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  4. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  5. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  6. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  7. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Tim Graham supported this idea  · 
  8. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  9. 14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  10. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Tim Graham supported this idea  · 
  11. 22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  12. 25 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  13. 649 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. 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.

    Guy Hunkin
    Excel Team

    Tim Graham supported this idea  · 
  14. 3,638 votes

    We're glad you're here

    Please sign in to leave feedback

    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]

    Tim Graham supported this idea  · 
  15. 486 votes

    We're glad you're here

    Please sign in to leave feedback

    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]

    Tim Graham supported this idea  · 
  16. 1,567 votes

    We're glad you're here

    Please sign in to leave feedback

    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

    Tim Graham supported this idea  · 
  17. 57 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for this idea. 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.

    Inbar,
    Excel Team

    An error occurred while saving the comment
    Tim Graham commented  · 

    I've been using the Named Range and =Excel.CurrentWorkbook() solution and that's working well enough. And this may be better (for me) than a Current Workbook + This Worksheet option since it helps to define a specific area to be queried and probably helps avoid potential issues arising due to adding things to the worksheet that are not really part of your data (comments, notes about what's included in the data, etc.) and that might mess up your query (if you didn't set up the query to guard against that or didn't realize you'd mess up the query by addin extra rows at the top, et cetera). But I could imagine there would be plenty of cases where someone doesn't need to, or want to, set up a named range to do this, and may not have concerns about "extra data" getting added to the worksheet, and to just query the current worksheet would be faster -- as may be Imke Feldmann's case.

    Anyway, I guess my suggestion now is more about making all this easier to figure out. I did a lot of Googling and bought "M is for Data Monkey" in order to figure it out. Just feels like it should be easier to discover than that. In my job, I always struggle with whether to ask users to enter numbers into a proper Excel table (which a lot of them don't like and can mess up easily), or entering it into a simple range, where you can direct their attention better. So for me, when I started trying Power Query, one of my first realizations was how great it is to now be able to have users enter to a range, and then be able to turn it into a TABLE and allow me to get the data into pivot tables -- best of both worlds. But then I almost lost my mind trying to figure out how to properly (and safely) query the current workbook when that workbook could end up having many different file paths / names over its life. This solution just seemed way too "hidden".

    Tim Graham shared this idea  · 
  18. 645 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Tim Graham supported this idea  · 
  19. 1,148 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

    Tim Graham supported this idea  · 
  20. 358 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Tim Graham commented  · 

    This seems like such a simple, basic thing and it's mind boggling that Excel doesn't already help you with this. If it can warn you that you have external links, why can't it tell you WHERE THEY ARE? Seriously, please fix. Thank you!

    Tim Graham supported this idea  · 

Feedback and Knowledge Base