Feedback by UserVoice

Corey Becker

My feedback

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

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to 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 since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    An error occurred while saving the comment
    Corey Becker commented  · 

    The latest explanation doesn't make sense to me. Sure, I get it's not easy because it's dynamic but conditional formatting is dynamic too isn't it? Isn't it already volatile? Does anyone have more info here?

    Corey Becker supported this idea  · 
  2. 626 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Corey Becker supported this idea  · 
  3. 757 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great news. We have started to rollout the Unhide multiple sheets dialog box improvement! It is currently available on Office Insider Windows- Beta channel build 16.0.13424.10000 and up.

    We are working on rolling this out to a general audience (Current Channel), as well as to Mac and Excel for the web. We will post updates here.

    If you are excited by this change or have comments for us, please share at File→Feedback.

    Thanks, Urmi

    Corey Becker supported this idea  · 
  4. 869 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Corey Becker supported this idea  · 
  5. 1,475 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

    Corey Becker supported this idea  · 
    An error occurred while saving the comment
    Corey Becker commented  · 

    Great idea. Being able to specify "Locked" by column would be nice. Also, unlocking the structure of the table itself so you can insert rows as you suggested.

  6. 18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for the web » Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Corey Becker supported this idea  · 
  7. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Corey Becker supported this idea  · 
    An error occurred while saving the comment
    Corey Becker commented  · 

    Wow. I didn't believe you at first. I just tried it and it worked. I'm not really sure how they can resolve this though, without creating a new file type that can't be downgraded to .xls

  8. 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
    Corey Becker commented  · 

    There were A LOT of people asking for separate windows. I agree they should provide the option but it certainly wasn't a dictatorial decision.

  9. 8 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
    Corey Becker commented  · 

    I'm guessing this will be low priority for them but I can offer you a workaround. In my version of Excel (2016), it already works like this. If you actually launch a new session (e.g. click on Excel in your Start menu), it should launch a new Excel session and keep your other session minimized. They recently allowed multiple windows within the same session which is probably the issue you're running into (hard to tell what's a separate window vs session). If you just open an Excel file from some folder, it will open in your existing Excel session so your other spreadsheets will all pop up. So just open Excel from your start menu and then open the file and the other files will stay minimized.

  10. 828 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    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.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

    An error occurred while saving the comment
    Corey Becker commented  · 

    Daniel's suggestion is an issue with chart's. Charting should be updated to allow that behavior. I use the error technique personally and all my sums ignore errors. Adding a null function seems like a workaround to fix real issues. We should just fix the issues you're trying to workaround.

    An error occurred while saving the comment
    Corey Becker commented  · 

    It seems that there are probably much simpler solutions to the examples listed below.

  11. 5 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
    Corey Becker commented  · 

    The 10,000 limit should only apply to the drop-down that you see in auto-filter. It's just a display issue. All your rows are still sorted/filtered, you just can't see all the options in that drop-down, that doesn't mean it doesn't apply to them. I suggest you always have an "IsFiltered" column on your table. This field can be driven by some cell/input/slicer/etc. It could be as simple as (in cell F2) =A2="Jelly Beans". Jelly Beans can be replaced with anything obviously, including a cell reference. You can also add multiple tests with AND/OR/etc.

  12. 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
    Corey Becker commented  · 

    I'm not sure how they could solve this exactly, but it would be nice. I've written some pretty nasty VBA to do something like this but it sucked.

  13. 4 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
    Corey Becker commented  · 

    I feel like there's probably a way to do this with a custom list or something. I think this idea should be part of making that process easier/more dynamic.

  14. 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
    Corey Becker commented  · 

    Oh god, definitely not a new file type. That was disastrous. Definitely agree this would be nice though. I think a summary with the data model and all data queries/connections would be nice. Icon or indicator would certainly be a start.

  15. 130 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
    Corey Becker commented  · 

    Jan, it's not what I "believe" to be bad practice. It just is. My favorite explanation of this can be found if you Google "Volatile Excel Functions Decision Models".

    You are trying to make a point by saying you have 43 sheets, but that's only confirming how terrible the spreadsheet is designed. As you continue to develop your Excel/data skills, this will become much more apparent. I'm simply suggesting to anyone reading that they avoid the mistakes I made early in my career.

    That being said, I know people find volatile functions as an easy stop-gap measure when they're not aware of their alternatives. That's perfectly fine until you start dealing with truly complex models. However, Microsoft should do a better job educating their users, not continue to support bad habits by expanding these workarounds.

    Your first example has several other alternatives.Give me an example spreadsheet containing an example of when you think INDIRECT is necessary and I will show you a better alternative. In doing so, it will be faster, more reliable, and more dynamic.

    An error occurred while saving the comment
    Corey Becker commented  · 

    Using volatile functions is bad practice. They are never the best solution. Sometimes they are the simplest, so for small, simple workbooks they're fine. If you have not noticed performance issues with INDIRECT then you don't deal with any large or complex spreadsheets. I've seen several people design these dynamic sheet name spreadsheets you're speaking about and I just shake my head. Data should be stored in a single table with a column to specify the attribute you're filtering on (as opposed to a separate sheet). Development should not focus on supporting bad habits.

    An error occurred while saving the comment
    Corey Becker commented  · 

    Not sure if someone mentioned this before but another issue with these functions is that they are volatile, meaning no one should actually use them in a large file. Also, I'm concerned this would lead to more people using INDIRECT, which is never a good thing.

  16. 224 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
    Corey Becker commented  · 

    You can link Form/ActiveX checkbox controls to a specific cell.

  17. 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
    Corey Becker commented  · 

    I like the idea of the sidebar but it needs a lot of work. Keyboard navigation is one thing. It's also not intuitive where anything is in my opinion.

  18. 29 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
    Corey Becker commented  · 

    This always seemed like a no brainer to me. Cutting is often times easier because it doesn't update the formulas, but then you have to reformat the pasted cells to match the formatting of their new home.

  19. 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
    Corey Becker commented  · 

    As any advanced Excel user will tell you, the better solution is to stop merging cells. It leads to sloppy spreadsheets. There is always a better way to design your spreadsheet. Use Center Across Selection for horizontal text. If you have vertical text, you're doing it wrong.

  20. 20 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
    Corey Becker commented  · 

    @JoeU, that really depends on your application though. You should not be doing theoretical mathematics in Excel. This suggestion is related to floating point arithmetic, not approximation. If you subtract 2-2, it should be 0, not 0.0000000001. The issue is related to conversion between binary and decimal, not your "reaches zero" heuristic.

    Corey Becker supported this idea  · 
    An error occurred while saving the comment
    Corey Becker commented  · 

    @Andreas Using ROUND was our workaround but rounding is not ideal in all applications. This suggestion is more related to the fact that Excel's correction for the floating point bug is not consistent.

    Corey Becker shared this idea  · 
← Previous 1

Feedback and Knowledge Base