Feedback by UserVoice

Ed Hansberry

My feedback

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

    We’ll send you updates on this idea

    Ed Hansberry commented  · 

    Actually just need another argument for the =CELL() function. =CELL("Sheetname",A1)

    Ed Hansberry supported this idea  · 
  2. 22 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 further details on Bullet charts. The Wikipedia article is a good reference. As we plan the next release, we’ll definitely consider this new chart type.

    Thanks,
    Scott [MSFT]

    Ed Hansberry commented  · 

    Please continue to investigate. As you can see here - http://peltiertech.com/bullet-charts-in-excel/ - this is an exceedingly tedious task to do by hacking other chart types in Excel.

    Ed Hansberry supported this idea  · 
  3. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry commented  · 

    that requires doing stuff every time data is brought in or pasted. A formula, once set up, works every time. I can do it with a formula, but it is a long formula using the DATE, YEAR, MONTH, DAY, TEXT, MID, LEFT, and RIGHT functions. Not quick to set up, and I suspect a lot more overhead than if it was just the DATEVALUE() function.

    While the method you mention *is* very handy for one time conversions, it does assume the date is in its own cell. That is often not the case if it is copied/imported.

    I just found it really odd that Excel supports it in the Get and Transform M Language functions, but not in Excel worksheet functions.

    Ed Hansberry shared this idea  · 
  4. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  5. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry commented  · 

    That makes it worse actually. It is why Facebook split out messenger. The code got so nasty it was difficult to update in one MASSIVE app.

    Google split out its Google Apps a few years ago too for this very reason into the spreadsheet, documents, etc. apps. Easier to keep stable.

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

    We’ll send you updates on this idea

    2 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry shared this idea  · 
  8. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  9. 44 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    When you say that it opens a different size – can you give more info? Do you mean the application window is a different size (it shouldn’t be) or that the font sizes (zoom) are different? (again, they shouldn’t be)

    Additionally, if you can post a video of what you’re seeing, that would be a big help for us.

    If there is a problem here, it’s definitely something we’d want to fix.

    Cheers,
    Dan [MS]

    Ed Hansberry commented  · 

    Dan, the Excel 2016 app seems to have a mind of its own when it is opened in anything but full screen. I have a Surface Pro 4 (high DPI) attached to an external monitor (low DPI) so that may be contributing to the issue.

    As an example, when I open a file on my Mac, it is *always* the same size. The window size doesn't change from session to session - the exception being is if I opened it on my iPhone and when I return to the Macbook, it is a postage stamp size. :-(

    But on Windows, Excel seems to make no effort to remember what size the window was. In earlier versions on Windows this was understandable as the files were all part of the same window, but in Excel 2016, each file gets its own window and that size should be remembered.

    Ed Hansberry commented  · 

    This goes for the Mac too. This is especially problematic when you open the file on a mobile device, like an iPhone.

    Ed Hansberry supported this idea  · 
  10. 21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    We’d love to get samples of these workbooks that are crashing, along with steps that cause them to crash. Until then, there’s not much we can do without more data.

    If you have such a workbook, please create a new idea entitled “I have a workbook that crashes, which I want to send you” and I’ll get back to you with an email address where you can send it so we can take a look and fix the problem.

    Thanks!
    Dan [MS]

    Ed Hansberry supported this idea  · 
  11. 72 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]

    Ed Hansberry commented  · 

    Allow negative offsets in the VLOOKUP (and HLOOKUP I suppose) function so we can find info based on data not in the first column of a table, and we don't have to mess with a tedious combination of INDEX and MATCH functions.

    Ed Hansberry supported this idea  · 
  12. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  13. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry shared this idea  · 
  14. 11 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 » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    This would be very valuable. Not only that, but I'd like to see when you open a file in Excel and it says it is read-only because someone is in it, offer to open in Excel Online as one of the options (besides Notify, Read Only)

    Ed Hansberry supported this idea  · 
  15. 49 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Excel for the web » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    Agreed. This should not be a destructive edit. I am ok with Excel Online not showing the info, like text boxes, but it shouldn't remove them from the file! Wasn't that part of the point of the new XML formats a decade ago? Data in the file could be ignored by the client if not supported, but not removed from the file.

    Ed Hansberry supported this idea  · 
  16. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry shared this idea  · 
  17. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Mac » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 
  18. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
1 2 4 Next →

Feedback and Knowledge Base