Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Adding accounts to Microsoft Excel Money

    I'd like to know if you could manually (by routing and account number) be able to add banking accounts to the spreadsheet and therefore automatically be able to import transactions. My bank accounts are not associated with Plaid and its really annoying.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for sending Microsoft feedback.

    Currently, Money In Excel supports financial institutions via Plaid. We appreciate your valuable feedback and we understand that providing the functionality to add accounts manually would be a great addition.

    We will pass-on this feedback to our concerned team.

    Best,

    Vipin V Nair
    The Microsoft Team

  2. Money for excel. I need my expenses to be reported from January 1, 2020. I am using this for tax purposes

    I need all my information with Excel Moneyto give me expenss back to January 1, 2020, not 3 months back from current date. This program is useless without having my expenses for the whole year. I am using this program for tax purposes.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for sharing your valuable feedback about using Money in Excel. Currently, Money in Excel template supports transactions back dated up-to 90 days from the day you first connect your account. We agree that importing transactions for the whole year would be a great feature, hence we will share this feedback to our apt team for review.

    Regards,

    Vipin Nair
    The Microsoft Team

  3. Stock data type, Expense Ratio column

    First of all, love the new Stock data type and can see this new feature getting better and better as time goes on.

    One thing I noticed right off the bat is that the Expense Ratio column seems to be locked at 2 decimal places. ***.XX% for example. Checking one particular index fund from Vanguard (VINIX), they have the expense ratio listed for this fund as 0.035% but the Excel column brings it in at 0.040%.

    It looks like their is either some rounding issue going on or the data source Excel is basing this off of has it saved…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for posting! I’m seeing that this is actually a bug in the data source and doesn’t have to do with a limit on the precision in the expense ratio field.

    You can verify yourself that the incorrect data is replicated on Morningstar here: https://www.morningstar.com/funds/xnas/vinix/quote.html

    Since this isn’t a feature request, I’m going to close this request as “declined”, and we will follow up with Morningstar about getting this fixed. For future reference you can report issues like this through the Excel “Send a smile” button in the top right of your Excel window.

  4. Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot

    Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!

    Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.

    304 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    28 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for posting and voting for this idea, but unfortunately we won’t be implementing it. Excel is a tool for a wide set of audience and while this may help to some, it may defintely confuse others. As a workaround, I suggest to use the Customize Ribbon option and add a new tab with you desired set of tools and commands.

    Guy Hunkin
    Program Manager, Excel Team

  5. Show Tables in Power Query when opening an xlsb file

    When using Power Query / Get Data to open .xlsx files and .xlsm files, the Tables present in those files are shown in a list.
    When opening a .xlsb file only Sheets are shown and not any of the Tables present within the file.

    If there is only one table on a sheet, AND it starts in cell A1, then it is relatively easy to still load the data, but where there are multiple tables per sheet, OR the tables don't start in A1, then there is a lot of unnecessary work deleting Rows and or Columns to obtain your…

    100 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    22 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow autosave/co-authoring for password protected workbooks

    When using co-authoring with Autosave in latest Excel desktop client, it fails if the workbook is password protected. Allow multiple users to edit a password protected workbook.

    101 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    23 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking the time to suggest and vote for this feature. We do not have plans to support coauthoring in password protected notebooks, but we are working to support coauthoring with protected documents in desktop clients. See here for more information: https://office365.uservoice.com/forums/928576-microsoft-information-protection-mip/suggestions/19696030-enable-co-authoring-of-protected-documents.

    Thanks,
    Pallavi H [MS Excel]

  7. Test

    Test, please ignore

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  8. Return share workbook functionality to Excel 2016

    Excel 2016 has recently removed the share workbook functionality and hidden the icon for easily sharing workbooks. It appears that this has not taken into account spreadsheets that are saved on file servers, and aren't uploaded into the cloud (ie the co-authoring functionality). Please return the functionality so that workbooks can be easily shared.

    100 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    The Shared Workbook functionality is a limited experience and did not support usage of many Excel features during co-authoring.  We chose to invest resources in building a full experience of co-authoring in Excel through Office 365.  It is not possible at this time to provide that functionality to on-prem servers.

  9. there is a problem with the clipboard

    "There is a problem with the clipboard, but you can still paste your content within this workbook" August 22, 2017 In Excel, under File/Options/General, please provide a switch so that users who like to be shown this message can see it, and the unhappy people, like myself, can switch this feature off. Almost every time copying is required ....#@&!!

    26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    23 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for sharing this feedback! If you see this issue, please use the in-app feedback in the File menu to send us more information, and include the steps you took before you saw the issue. That will give us the information we need to further investigate.
    -Sharon

  10. Default pivot table's to default to "Sum" rather than "Count"

    I would like the default on pivot tables to go to "Sum" rather than "Count" or have an option for the user to select what the default is.

    22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    The default is already SUM as long as the data in the field is numeric. It changes to COUNT when there are text values in the data because we cannot SUM non-numeric data. The current behavior is the intended design.

  11. Axel - Combining Access and Excel into 1 excellent product

    Hello,

    I have been developing with Access and Excel for the last 17 years, it is my bread and butter and while I use VBA to communicate between the two I had the following thought...

    Wouldn't it be great if a new product came to market that contained both Access and Excel objects?

    Viewing Form tabs alongside Excel Worksheets in the same development window, showing sheets as objects in the same pane as tables and queries etc.

    A benefit of both data storage and calculations plus it would certainly be faster.

    You could call it Excess or Axel

    It would…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    While we won’t be merging Excel and Access into a single product, we have been doing a lot of work in Excel to make it work better with data. Power Pivot, Power Query, and the Data Model are all tools that let you pull data from multiple sources, join and manipulate that data, and then do all of the ad-hoc reporting on it that you are used to doing in Excel.

    Cheers,
    Dan [MS]

  12. please add persian calendar (hijri shamsi) in excel 2013 (as like as 2016 version)

    Some people who use Persian calendar in excel, need to do calculation on date; some apps help them in this way but these are not perfect and they affect on other procedures... this problem is solved by Microsoft in 2016 version... So if it is possible, please add Persian calendar (hijri shamsi) in excel 2013 too.
    I am looking forward to see it in your next updates... thank you very much.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    We’re unlikely to add this in previous versions of Excel, as we don’t have regular updates of those versions, as we do with OFfice 2016.

    Cheers,
    Dan [MS]

  13. Remove gross Yellow Smiley faces from all office applications

    I've tried registry edits nothing works it looks unprofessional and is a big distraction.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    The yellow smiley faces are a paradigm that we’ve used across Office for sending feedback to Office engineers for things that are great (Smile) or not so great (Frown).

    They’ve been there for years, and aren’t something that we “control” on the Excel team, so they aren’t something that we’re going to remove.

    Cheers,
    Dan [MS]

  14. Ability to Cut without adding to clipboard

    Sometimes I have to remove a graphic and replace it with a newer version.
    To do this currently I use CUT and then have to copy the new graphic and paste it.
    I'd like to be able to simply CUT the old graphic then PASTE pasting the new graphic (currently the way it works, it would just re-paste the graphic I just cut)

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    The paradigm of placing “Cut” content onto the clipboard is something that is consistent across Windows, Mac, and mobile platforms. As such, we’re very unlikely to change it within just Excel.

    Cheers,
    Dan [MS]

  15. VBA formulas same as excel formulas

    I would like to see the abiltiy to use any excel formula used in VBA, with the same syntax.

    For example-Range("A1").value = ExcelFormula.=countif(B2:B30),testing

    Something like that to signfiy to vba that an excel formula in the exact same way that it is used in VBA, so you could even cut and paste any formula between excel and VBA.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    We have no plans to structurally update the VBA environment (see “Bring VBA into the modern world”). However, you can work with Excel functions in VBA already, using the WorkbookFunction object. The syntax is still VBA-like instead of Excel-like, but the functionality is there.

    Alternatively, you can use Evaluate, as Kenneth suggested:
    Dim x As Double
    x = Evaluate(”SUM(A1,A2)”) ‘Evaluate function
    x = [SUM] ‘Shortcut

    Cheers,
    Dan [MS]

  16. Expand possible locations in "Add a Place"

    Add a Place allows us to choose from iCloud Drive, Office 365 SharePoint and OneDrive.
    Could we add the choice to connect to other location such as a G Suite account in order to be able to save or save as in Drive.

    The only way around so far is to install the third party add in "Google Drive".

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This list can be customized, but only via add-ins as you’ve already noticed. The reason for that is that Office needs to know how to communicate with those storage locations, and each works differently – that’s what the add-in does.

    There’s no way for Office to allow you to enter a URL and have things “just work,” unfortunately.

    Cheers,
    Dan [MS]

  17. Bring back the menu instead of the ribbon

    The ribbon is awful and requires a bunch of re-learning every time we upgrade versions. I want the menus from excel 97-2003 back, if only as an option for "power users"

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    The ribbon is a cross-Office, cross-Microsoft, and now cross-industry paradigm for UI. At this point we will not be switching out the ribbon in Excel for menus/toolbars.

    Cheers,
    Dan [MS]

  18. Manage SQL Server table content

    I wish there was a simple way to manage data in an SQL Server table using Excel. We can read the data with current tools, but I hope we could also insert and update data using Excel.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This is an interesting idea, but one that we’re not going to integrate into the Excel product. Excel is really about connecting to, cleaning, and analyzing your data – it’s not about schema management or SQL Server management.

    A better tool to do that management is Access, or the free Microsoft SQL Server Management Studio.

    Cheers,
    Dan [MS]

  19. Allow indirect conditional formatting to adjust when columns are inserted

    Right now, if you use indirect conditional formatting, and a column is inserted between the formatted cell/column and the cell/column that drives the formatting, the indirect reference does not adjust.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    INDIRECT uses strings to generate references. There is no way for Excel to know if the strings in INDIRECT should be adjusted or not – so they never are (in regular cell formulas or CF).

    Cheers,
    Dan [MS]

  20. A spread sheet for farmers to keep track of their CCA

    I would like to see an excel spreadsheet set up for farmers to track their CCA class, asset descriptions, market and purchase value of equipment, trade in values etc Right now I have to try and set it all up myself. would be handy to have a sheet all set up

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5
  • Don't see your idea?

Feedback and Knowledge Base