Feedback by UserVoice

Excel for Windows (Desktop Application)

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. Change the default method for data pasted from Access so that text isn't formatted to wrap.

    Text in data pasted from Access always formats as wrapped. Make the default to be not wrapped, or provide an option to specify whether the text should be wrapped or not.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. Paste function uses previous "text-to-column" settings without notice

    The past function seems to use the same settings as those last used in the "text-to-columns" feature. The user has to figure this out retroactively though, and it can be incredibly confusing. For example, if a "." delimiter was previously used then any future pasting will split all numbers at the decimal. Often time will have elapsed since the last use of this and the user doesn't realize why the paste feature seems to suddenly be acting strange.

    I'd suggest either removing this, having there be a point at which the paste function resets to defaults rather than persisting in…

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Fix the Web Query Error

    When I do the web query import. I keep getting this error. I can click past it but can you clean this up?

    An error has occurred in the script on this page

    Line 2
    Char 2120
    Error Unspecified
    Code 0
    URL

    Do you want to continue?

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow Older Models of PowerPivot to be upgraded

    There are lot of sample files of PowerPivot on the web but when I try to open them they won't upgrade. Can you try to make powerpivot backwards compatible.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. Better support for images and attachments

    I was using PowerBI and I imported various spreadsheets but I learned the hard way the limits of the spreadsheet. I need to be able to attach images and files inside of spreadsheets. Also, I would like to get access to the extended files in PowerPivot when using PowerBI.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. Feasibility to query Google Calendar to Excel

    Many times, I have to see my calendar to calculate hours that I spent for meetings. It is kind of monotonous work that a professional has to spend specially in "productivity" calculation. If Excel can built a query in Power Query tool or import from data sources which gives an option to export data from Google Calendar or any other calendar and we can built other formulas to calculate productivity efficiently.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  7. creating Layout of directory in excelsheet directly from your local hard drive

    if it was possible that just with one click, we can create a Tree Grid Map of directory, which will give option of inducing sub folders & files with option of inserting hyperlink.

    So that i don't have to open 7-8 sub folders before opening my files.

    (nothing against VBA, its a great tool) if i create a directory using VBA it is not very beautiful..... i wish i could see small folders with little Expansion buttons it would be very great.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Mirroring Worksheets

    Sometimes I want to present some information to a client, but not all. Linking doesn't always work due to the possibility of inserting new columns or rows into the data. I would like to clone a worksheet and designate the original as the master worksheet. In the clone, I'd like to change formatting, hide cells, or add information, while mirroring the master data so I can keep my master data and still generate reports for others from the clone.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. Query Stability

    Hello, I love the new 'Query' features in 2016, but it's too unstable to use. I have sent many 'frowns' from that form i am often seeing.

    I am commonly working with multiple connections to view and tables on an SQL server. Using the 'old' method "from other sources" is slower to setup the connections. But is 100% stable. Using the "Recent Sources" and getting the data that way, very often the data wont load or crashes my excel.

    I have been trying this new feature for a few months now to give it a chance. But today I give…

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  10. Speed up xml import

    Importing data from xml file into a Listobject (Table) is very slow. FIle containing 100.000 rows runs 10 minutes. Importing the same data from txt runs 5 secs.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. Excel 2016 Desktop Power Query takes ages to refresh from Azure SQL Database. Make refresh faster.

    In Excel 2016 Desktop, it takes very long time for Query to refresh from Azure SQL Database (such as Access Web Apps database). Even when the whole Query is connecting to a single small table, refresh takes + 5 minutes sometimes. This Refresh should be made faster.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add Running Totals Function in power query

    Add a running total function to power query

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

    We’ll send you updates on this idea

    5 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  13. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    I received email back from Sam saying he’s expecting this to be the Table Analysis functionality (like key influencers, highlight exceptions), and not the explicit Data Mining features (like clustering). Am going to update the title, and we’ll wait for more votes before considering this item.
    Thanks, Sam!
    Ash

  14. Show "Data" > "From-Text"-Wizard by default when double-clicking *.csv files...

    When double-clicking CSV-files Excel automatically tries to guess the column formats and assumes the default field seperator.
    But this often wrong column-types are guessed and it fails for *.csv-files with unusual field seperators.

    It would be better if double-clicking a *.csv file would open an import-wizard (like the existing one from "Data" > "From Text").
    - The types for the columns should default to a text-type.
    - It should not try to guess column-types automatically, but one might let excel guess manually via a button "Guess column types" in the wizard
    - The most probable* field seperator should be pre-selected …

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

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  15. Power Query needs to pulls over Dax formulas from Excel Data source

    Could not create measure 'Demand'[BOMQty] - 'MRR'[RecvQty] in Power BI DeskTop

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Power Query Data Type Fraction

    Would like to be able to convert text type to fractions. Example: 3-1/2 or 3 1/2 etc to 3.5 and have ability to have leading zero format.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. Recent Query and Connection issue

    Recently after update I spot that my Power Query is not connecting to my Organizational account and moreover when I want to download something from web --> Connection Properties --> Edit Query... does not work properly.

    Multiple pictures attached.

    Please fix this as soon as possible

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  18. Convert Text to Columns - Permit Paste into the "Other" character. Non-Printable chars

    In the Convert Text to Columns Wizard, allow the ability to Paste a character into the "Other" Delimiter textbox.

    This enables the ability to parse text files that use non-printable chars as delimiters. eg: ASCII's Unit Separator char (Alt+031), or various UNICODE chars.
    These types of separators avoid all the issues with CSV & other common delimted text file formats. Where valid text is confused with the field delimiter.

    This option is supported by most MSFT products; eg: MS-Word, SSIS, PowerBI but ironically not Excel.

    Note: PowerQuery does offer the ability to paste the char into it's custom Split.Column by…

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. 0 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. Configurable option that automatically names the worksheet tab created by a query load

    when you load data to a tab, the tab name is "sheet2" but you should add a configurable option that will name the tab the same as the table name that is created when the data is loaded.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base