Feedback by UserVoice

Excel for the web

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 web version of Excel's feedback forum! This is the place for users to send us suggestions and ideas on how to improve. 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. Power Query: Make it easier to connect to files on OneDrive and SharePoint

    Connecting to Excel files stored on OneDrive and SharePoint is a difficult and confusing experience. While it is possible, it is far too difficult.

    As more and more move to working in an online environment we need a simple way of connecting.

    255 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

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

    Thank you for showing passion for Power Query and various improvements! We are indeed looking to implement this suggestion.

    In general, we’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like these ideas.

    Thanks!
    Jonathan Kahati
    [PM @ Excel]

  2. 236 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

    38 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for your continued suggestions and votes. We’re currently rolling out a format task pane for charts and are investigating incorporating this feature as we continue to support more formatting capabilities on Excel Web.

    Thanks!
    Auston, [MSFT]

  3. When files are locked by another user

    It would be good to have a way to notify person who has locked the file out that is shared to close it by clicking a button

    82 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

    Accepting Votes  ·  2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  4. 3,117 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

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

    Thanks for your feedback! We’re reviewing your suggestion. Please keep voting to influence our Backlog priority.

    - Excel on web team

  5. Enable protecting/unprotecting worksheets in excel online without needing to edit in Excel

    Enable protecting/unprotecting worksheets in excel online without needing to edit in Excel

    407 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

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

    Thanks for your feedback! We’re reviewing your suggestion. Please keep voting to influence our Backlog priority.

    - Excel on web team

  6. Allow Full Collaboration Only (Prevent File Locking)

    This idea is all over this forum for a very long time in different wordings. Clearly this is a huge issue.

    MS, PLEASE add an option for files stored on Share Point and One Drive to "Only allow editing in full collaboration mode". This would mean a file would only be editable in the desktop version of Excel if the user is running 2016 and properly signed in to their Office365 account within Excel, thereby preventing file locking for other users.

    If not the solution above, at LEAST allow us to set a file to "Edit in Excel Online Only".

    34 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

    Accepting Votes  ·  2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add custom error bars to Charts in Excel Online

    My students need to be able to add previously calculated error bars to column graphs (to make a bar graph of means +/- standard errors). Adding this to the online version will make it easier for groups to be able to collaborate in real-time using the online version. This would make Excel online beat Google Sheets hands down for me.

    168 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

    41 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for your suggestion and votes. We’ve recently rolled out a format task pane for charts and are investigating incorporating error bars as we continue to add more formatting capabilities for Excel Web.

    Thanks!
    Auston [MSFT]

  8. Please add the abilty to copy charts from Excel online in order to paste into other apps

    Hi, I have set up charts for data visualisation within Excel that I would like others to be able to use in their reports and presentations. Unfortunately Excel Online does not appear to allow you to copy a chart.

    Is there a workaround (that doesn't mean the user opening in Excel desktop and thus locking the file) or could this be added please?

    Thank you.

    94 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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    You can currently copy a chart from Excel Web and paste it into other office applications as a picture. We’re investigating expanding copy/paste from Excel Web to do more, so please continue adding votes if this is a feature you are looking for.

    If you are working in Office 365 versions Excel for Windows and Mac, opening the workbook from your desktop applications will not lock the file for others.

    You can learn more here: https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

    Thanks!
    Auston [MSFT]

  9. Download complete original file from Excel Online

    When you download a file from Excel Online, some features that aren't yet supported by Excel Online are deleted from the downloaded copy of the file. Textboxes are a good example of an unsupported feature that is deleted from downloaded files.

    Removing unsupported features is a problem if I use OneDrive to hold files for download by webinar participants because I put a lot of explanatory content in those textboxes.

    I want to use OneDrive instead of DropBox for these file downloads, but won't do so if content is stripped. Right now, the only way a user can get the…

    61 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

    Accepting Votes  ·  9 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  10. Enable the drop-down list feature in Excel Online for Read Only Files

    Allow users to manipulate data through drop down lists and view the file.
    The online version of Excel doesn't allow the drop-down box option to work in files in Read Only mode.

    -- Updating title to make it more clear
    [Excel on Web Admin]

    291 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

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

    Thanks for your feedback! We’re reviewing your suggestion. Please keep voting to influence our Backlog priority.

    - Excel on web team

  11. Access On-Premise cube from Excel Online

    We are interested in creating Analytical reports (pivot tables with slicers) with Excel and host in Excel Online against our On-Premise MOLAP and/or Tabular Analysis Services cubes. Looks like to do this with Excel Online, a powerpivot model would need to be in the Excel Workbook. We'd like to create several Analytical reports against the same cube On-Premise (or access a common Power BI dataset).

    Today we have Analysis services MOLAP and Tabular models hooked to Analytical reports hosted in Sharepoint 2013 On-Premise. Users can slicer/dice and drilldown.

    We are looking for this same functionality in Excel Online. Many of…

    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

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

    We are working to improve Excel connectivity to Power BI including connectivity from Excel Online. Power BI does offer gateway servers to enable Power BI connectivity to on-premise data. Excel Online does not currently have plans to build its own gateways, and therefore doesn’t have a way to cross a company’s firewall and reach data that is located in on-premise servers. Bottom line is that databases in the cloud will eventually be reachable from Excel Online, but on-premise data can be accessed only from Power BI, and not from Excel Online.

  12. Online scripting language

    Include a scripting language on the online version in the same way that Google sheets does. The ability to automate excel on the desktop version via VBA is where the real power of excel is, the online version is therefore significantly handicapped by the lack of any scripting language. Power users need the ability to automate spreadsheet tasks.

    156 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

    Accepting Votes  ·  14 comments  ·  Macros, Scripts and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. Don't provide a warning on Pivot Chart refresh

    Don't provide a warning on Pivot Chart refresh. I have a Pivot Chart which I right-click and press refresh, and I receive a warning that I need to be in a cell to perform a refresh.

    The warning should not be displayed.

    8 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

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Good feedback. We’ll take this into consideration for our next planning phase. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  14. Save as CSV

    It would be great if you could add "Save as CSV" file format to the Save As feature.

    335 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

    Accepting Votes  ·  22 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  15. form controls

    Form controls for dynamic charts: #1 spinner control, #2 slider/scroll control. Adding form controls to spreadsheets online would practically close the gap to share analysis / scenario spreadsheets. Please add the spinner control (first priority) and secondly the slider / scroll

    29 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

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    Thank you for your suggestion and votes for Form Controls. There is currently no planned work for this as we are focusing on other feature areas. We will continue to accept votes on this and will notify you if our plans are updated.

    Thank you!
    Auston, [MSFT]

  16. ability to create multiple versions of the same chart for a different variable

    or, make statistical analysis easier
    or, take ideas from SAS JMP and Tableau

    One of the tools for analysis is showing the same chart but for different sub-sets of the data. for example. a scatter chart...but then a scatter chart for each subgroup. (so, if you're looking at X, then also look at X for ages 0-25, 26-50, 51-75, 76-100) (and you end up with 4 charts all should the same thing except one for each subgroup)

    11 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

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Interesting idea. Thanks for the feedback. We’ll consider this in our next round of planning for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  17. Fix Charts inconsistencies which require you to delete items to fix them.

    I run into bugs where changes I make on a chart in excel don't make it to excel on-line. For example, I changed font characteristics of 3 data labels for a chart. On excel on-line, 2 where changed and one wasn't. To fix, I had to turn off all the data labels and recreate them.

    5 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

  18. All Excel Charts Should Support for SSAS

    Enhance all chart types to support SSAS/Power Pivot

    7 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

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  19. Add / Edit charts online

    One of those things that are badly missing online is the ability to add and edit charts in Word.
    In my opinion, add/edit charts is the simplest way to create compelling documents that look good and are easy to share/edit with anyone without going through Excel which some users a really not very much used to, especially at the C-level.

    27 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

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    While we do not yet support chart editing on the web version of Word, we’re happy to announce that we have released an improved chart editing experience for Excel on the web based on your feedback!

    Once the update reaches you, it can be accessed through the “Format” button, found by right-clicking on a chart or by selecting a chart and navigating to the “Chart” tab that appears in the ribbon at the top of the screen. Thank you for your continued feedback and responses.

    Thanks!
    Auston [MSFT]

  • Don't see your idea?

Feedback and Knowledge Base