Feedback by UserVoice

Dory Owen

My feedback

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

    We’ll send you updates on this idea

    Dory Owen commented  · 

    Unhide with a multi-select checkbox list. Yeah! Let's do it!

    Dory Owen supported this idea  · 
  2. 49 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen supported this idea  · 
  3. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen supported this idea  · 
  4. 144 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen supported this idea  · 
  5. 201 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion, thanks David! And thanks to other people who took the time to clarify/comment on this one. There’s definitely room to tighten this experience up in a number of places. We’re getting a lot of traffic on the site, so please keep voting for the things you care about most to help us do a great job of prioritizing.

    Best,
    John [MS XL]

    Dory Owen supported this idea  · 
  6. 798 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)

    Dory Owen supported this idea  · 
  7. 257 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi folks,

    Thanks for your passion around this. We’ve been discussing this item off and on for some time now and we’d love to get your input.

    The reason we’ve resisted this is because the R runtime & various packages (and updating their versions) aren’t straightforward for other users to install. This limits sharing such queries across a workgroup.

    What do you think?

    For others reading this that’d like us to prioritize this work, please be sure to add your vote since we’re prioritizing our backlog based on these.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Dory Owen supported this idea  · 
  8. 267 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen supported this idea  · 
  9. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen commented  · 

    Great suggestion. I even tried to get the Last Refreshed date from Workbook.Queries collection - even though I can see that date displayed in the Query preview. Nope. I need my users to know how fresh that data is.

    Dory Owen supported this idea  · 
  10. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen commented  · 

    I agree with this feedback. Need more direction on what next generation of Office dev will be. The post above sums up situation well.

    Maybe Visual Studio Code to replace VBE?

    Dory Owen supported this idea  · 
  11. 297 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen commented  · 

    The biggest problem I have is other users who accidentally create external links when they copy formulas from one workbook to another or do VLOOKUP to ext file. Then they mail their workbook to me not realizing that it contains references to data on their own C: drive. I look at the data and see a fixed total, they look at the same file, formulas update and they see a different total. When opening the file, it warns me that there are links to external docs, so I search around to figure out where this stuff is so I can resolve it. Could be in formulas, in Named references, etc. Need a diagnostic tool similar to the "Show Dependencies" or "Name Manager" that makes all this easier:
    https://support.office.com/en-au/article/Find-external-references-links-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1

    If user is about to Send as Attachment a warning about external references would be useful. Tells the sender they need to cleanup with PasteValues first.

    Dory Owen supported this idea  · 
  12. 442 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen supported this idea  · 
  13. 76 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for taking the time to post a suggestion Malcolm! We’ll be taking a look at lookup functions. There’s a number of votes on the site for them – I’m not going to merge all of them though because different posts are asking for slightly different things. Please keep voting for the ones you want to see most!

    Cheers,
    John [MS XL]

    Dory Owen commented  · 

    Maybe some new functions to replace the complex INDEX, MATCH stuff as seen at the link below.
    http://trumpexcel.com/2013/09/excel-index-function-its-magical/

  14. 23 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen commented  · 

    This would help me demo the complexity of legacy workbooks that need refactoring to simplify, flatten that dependency tree. Also, can check if any refs to a sheet before removing it. Current methods Ok but require a lot of fiddling, clicking precision, housekeeping to show/remove errors.

    Dory Owen supported this idea  · 
  15. 45 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dory Owen supported this idea  · 

Feedback and Knowledge Base