Feedback by UserVoice

 

Gerdami Des Betes

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Introduce #N/F as a new ERROR.TYPE besides #/A

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes shared this idea  · 

  2. MAXIFS should return #N/A upon no match

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  3. Show Recently Used Folders as the Default for Save As Function

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  4. Open multiple files with the same file name

    23 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  5. Remove unused styles

    16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes commented  · 

    Why not simply add the RemoveStyles button available from https://archive.codeplex.com/?p=removestyles ?

    Gerdami Des Betes supported this idea  · 

  6. New *IFs function to accept any aggregating function

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes commented  · 

    Yes, I was about to ask for MINIFS and MAXIFS.

    Gerdami Des Betes supported this idea  · 

  7. Increase the 218 character filename length limit to open files in excel

    668 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    215 comments  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Hello,

    Thank you for your continued feedback! We are happy to let you know that the work to enable this feature has started. We’ll share more details as we make progress.

    Thanks,
    David [Microsoft Excel Team]

    Gerdami Des Betes commented  · 

    @Jon (April 1 2018) is right, see:
    https://msdn.microsoft.com/en-us/library/windows/desktop/aa365247(v=vs.85).aspx
    https://social.msdn.microsoft.com/Forums/en-US/fc85630e-5684-4df6-ad2f-5a128de3deef/260-character-explorer-path-length-limit
    https://lifehacker.com/windows-10-allows-file-names-longer-than-260-characters-1785201032

    Gerdami Des Betes supported this idea  · 

  8. Improve the Conditional Formatting Manager

    286 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    55 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    Gerdami Des Betes commented  · 

    While I welcomed predefined conditional formatting rules with Excel 2010, I found that the original version was easier to manage.

    On the web you can find articles about "conditional formatting nightmare", such as

    http://blog.contextures.com/archives/2012/06/21/excel-2010-conditional-formatting-nightmare/

    Just another example: if you want to grey #N/As, intuitively you may try "cell value = #N/A": it does not work. You have to use a formula such as "=ISNA(cell)".

    Please make it simple to use!

    Gerdami Des Betes supported this idea  · 

  9. Support inline variables in formulas (similar to PowerPivot)

    18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes commented  · 

    Or something like this

    =VAR(X=expression, Y=expression [, ...]), IF(evaluation of combination of X and Y, value_if_true_perhaps_based_on_X , value_if_false_perhaps_based_on_Y)

    Gerdami Des Betes supported this idea  · 

  10. Opening two workbooks with same name

    20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes commented  · 

    Duplicate idea of https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/19995313-opening-two-workbooks-with-same-name

    Gerdami Des Betes supported this idea  · 
    Gerdami Des Betes commented  · 

    I fully support this idea.
    I regularly download same files from same statistical office and I need to open them at the same time to see the changes. For now, I have to rename the new files.

  11. Finally allow multiple open files with same base filename

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  12. Make it easier to find external links

    285 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    28 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes commented  · 

    Wow, it is already under review ... since 24 September 2015!

    Gerdami Des Betes commented  · 

    I have been using the utility by Bill Manville who commented below. Thank you Bill.

    Gerdami Des Betes supported this idea  · 

  13. Find and replace in selected cells - not Within workbook

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes shared this idea  · 

  14. Add a step or staircase chart to Type Of Charts

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes commented  · 

    Step charts are useful to display
    - changes in the Federal Reserve's monetary policy
    - snowfalls overnight
    - ...

    On step charts workarounds, see
    - Michel Gerday's post at http://www.excelforum.com/excel-charting-and-pivots/513287-dynamic-step-chart-using-range-names.html
    - https://www.pcreview.co.uk/threads/dynamic-step-chart-using-range-names.2397135/ (same as above)
    - Jon Peltier's HowTo at https://peltiertech.com/Excel/ChartsHowTo/StepChart.html
    - Minda Treacy's post at https://www.myonlinetraininghub.com/excel-step-charts
    - Michel Gerday's further comment at https://www.myonlinetraininghub.com/excel-step-charts#comment-19997

    Gerdami Des Betes supported this idea  · 

  15. Allow >31 characters in a sheet name

    21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    12 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  16. Remove the 255 character limit in Excel object model functions

    26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 

  17. Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

    1,176 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    908 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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

    Gerdami Des Betes commented  · 

    Please don't shout !

  18. Add ability to collapse field areas in PivotTable Field and Area Side by Side view

    435 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    10 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Ashvini Sharma (Lead Program Manager, Microsoft) responded

    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]

    Gerdami Des Betes supported this idea  · 

  19. Enable user to pin Folders to the recent lists for Open and Save As

    443 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    50 comments  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes commented  · 

    How can Microsoft be so stupid by removing recent and pinned folders ?
    :-(

    Gerdami Des Betes supported this idea  · 

  20. Put the color back in the Quick Access icons. The 2016 icon are impossible to decipher.

    187 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    152 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Gerdami Des Betes supported this idea  · 
← Previous 1

Feedback and Knowledge Base

(thinking…)