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. Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

    It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

    This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

    It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

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

    We’ll send you updates on this idea

    10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow interaction with Excel while in Power Query

    Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.

    The current behaviour makes it very difficult to do things like the following:
    -Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
    -When we have a static table in Excel and are trying to build a query that lands an…

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

    We’ll send you updates on this idea

    19 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. "Power BI Service" as a data source in "Get & Transform"

    It would be awesome if "Power BI Service" is added as a data source under "Get Data" in "Get & Transform Data" in Excel. Though the source availability is already there with "Power BI Publisher Add-in" but it is buggy and hard to deploy on large number of laptops/desktops. Also, it is practically very difficult to educate down the line users about re-enabling this add-in via COM Add-ins in case it disappears from the ribbon which is very frequent in case of this add-in. We have been struggling with this for a long period of time now.

    Considering "Power BI…

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

    We’ll send you updates on this idea

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

    Hi Deepak,

    Thanks for logging this issue. I agree this would be quite useful, especially as Power BI is emerging as a hub for business data.

    This request is slightly different than what PBI Desktop does. PBI Desktop essentially provides a Live Connect essentially deferring the model to the service and limiting the experience to visualizations so it’s not importing data into the report. So there’re two possible outcomes you could be looking for:
    1. Allow users to import data into Excel as query tables, just like one can from an external store like SQL Server or Oracle. This provides fine grained data retrieval.
    2. Create a new PivotTable that summarizes data on PBI service.

    The PBI Publisher addin performs #2. Is that what you’re looking for? Or would you rather have #1 if you had to choose?

    Others coming new to this suggestion, please be sure to add your…

  4. Be able to protect Power Query with password

    Now any user can edit and change Power Query connections, it would be very interesting to be able to protect Power Queries with a password.

    Thanks

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

    We’ll send you updates on this idea

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

    Hi Joana & others,

    Thanks for logging this suggestion. Yes, being able to protect your queries would be quite useful indeed for delivering solutions. We’ll prioritize this based on the interest, so if you’re reading this and haven’t voted as yet, please do so.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  5. Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month Number and Fiscal year

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

    We’ll send you updates on this idea

    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add "Run R Script" option to Excel 2016 and Excel 2013 "Power Query" add-in, as it is for Power BI.

    In July 2016, a "Run R Script" option was added to Power BI Desktop. This option would be a huge benefit to have in Excel 2016 and Excel 2013 Power Query add-in also.

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

    We’ll send you updates on this idea

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

    Hi folks,

    Thanks for your passion around this. We’ve been discussing this item off and on for some time now and we’d love to get your input.

    The reason we’ve resisted this is because the R runtime & various packages (and updating their versions) aren’t straightforward for other users to install. This limits sharing such queries across a workgroup.

    What do you think?

    For others reading this that’d like us to prioritize this work, please be sure to add your vote since we’re prioritizing our backlog based on these.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  7. Allow PowerQuery to Extract Data from PDF tables

    Allow PowerQuery to import tables of data from PDF files.

    53 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 →

    Thanks for logging this suggestion, Terry. This is a frequently asked requests, as evidenced by the number of votes on the article Ken linked to on the Power BI user voice site.

    We’re looking at this one, and in the meantime more votes would help us prioritize this work higher.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  8. If pasted text is auto converted to a date: _save_the_original_text_. Then give it back when text is desired. Don't corrupt data!

    When people in computational biology paste a list of gene names sometimes genes like "SPET8" are in the list. The original value is lost, and now the column has corrupt data. (Why did you kill the original value?) Since the column of gene names usually goes off screen and is often in alphabetical order nobody notices this until something breaks in a bizarre way in another person's hands. Scientific papers have had corrupt data for this reason many times, and everyone advises each other to avoid excel for this reason. It might even make a difference for a clinical diagnosis.…

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

    We’ll send you updates on this idea

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

Feedback and Knowledge Base