Feedback by UserVoice

Stephen Eddleston-McGrath

My feedback

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

    We’ll send you updates on this idea

    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

    John, Excel

    Stephen Eddleston-McGrath commented  · 

    Just adding my voice to this.
    Excel's File/Open functionality has become much more click-intensive (you click Open, THEN have to browse to get to your familiar folder structure with all your favourites in place). A quick way around this is to open Windows Explorer, and select files from there. That now launches a whole new instance for every file EVEN IF YOU MULTI-SELECT FILES IN EXPLORER.
    This is crazy. You can't link the files any more when this happens, and if you have a Personal Macro workbook, you get a warning that it is already in use for every single file opened. So I now have 5 files open with 5 copies of Personal.xlsm.

    This new behaviour is just not useful and we need to have an option to turn it off. PLEASE!

    Stephen Eddleston-McGrath supported this idea  · 
  2. 586 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stephen Eddleston-McGrath supported this idea  · 
  3. 216 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good news! We have released a few fixes to Insiders to address this issue. If you are on Insiders, please let us know if the fix has worked for you.

    The fixes should be in build 11809.10000 and onwards.

    -Joe McDaid [Excel Team]

    Stephen Eddleston-McGrath supported this idea  · 
  4. 542 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stephen Eddleston-McGrath supported this idea  · 
  5. 151 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stephen Eddleston-McGrath supported this idea  · 
    Stephen Eddleston-McGrath commented  · 

    I also fully support this idea. It is a much more comprehensive solution than just correcting chart behaviour. Shirley's example below is just one of the other uses that this could have. As mentioned by Daniel, allowing null values to work as in calculations (and return a null value) would hugely improve average calculations in complex financial models. Having to programmatically account for division by zero errors is a ballache at the best of times. If there is no data, the calculation should be allowed to return null.

  6. 75 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]

    Stephen Eddleston-McGrath commented  · 

    A consolidation of the INDEX and MATCH functions to provide a "crosshair" lookup would be handy
    CROSSHAIR(ColumnArray,ColumnMatch,ColumnMatchType,RowArray,RowMatch,RowMatchType)
    Where ColumnArray is the vertical area you want to search, and ColumnMatch is what you are looking for. ColumnMatchType is the match type (will usually be exact match).
    RowArray, RowMatch and RowMatchType are the equivalents for the horizontal area. The result will be the contents of the cell at the intersection.

    This saves referencing the entire area bounded by the ColumnArray and RowArray in the INDEX function, and would also avoid any mistakes caused by the Column and Row areas not intersecting at their top left point.

  7. 254 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]

    Stephen Eddleston-McGrath supported this idea  · 
  8. 666 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 again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    Stephen Eddleston-McGrath supported this idea  · 
  9. 526 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion E Bow. Thanks for taking the time to tell us about changes you’d like to see – we’re listening. We’ll take a look at this one. As always, folks should keep voting for the things they like the most – we’ll generally be prioritizing things according to the number of votes they get.

    Cheers,
    John [MS XL]

    Stephen Eddleston-McGrath supported this idea  · 
  10. 1,682 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Stephen Eddleston-McGrath supported this idea  · 
    Stephen Eddleston-McGrath commented  · 

    I agree, but I would also like to add a related issue - when text entered in "scientific format" gets converted to a number. In our organisation we have cost centres formatted as 4 numbers, 1 letter and 2 more numbers. So if we enter 7543E03 for example, Excel converts it to 7,543,000 (and displays it as 7.54E+06). We would love to be able to turn this option off. Actually, we would like to be forced to turn the option ON if you want it! No-one ever inputs numbers in scientific format, so it should not be the default behaviour.

Feedback and Knowledge Base