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.
-
Pull Current Stock Prices and Historical Data Into Excel
Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.
It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.
770 votesProgress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*
We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs
Again, we genuinely appreciate your involvement as we…
-
Power Query - cache shared nodes
Update Power Query in Excel to take advantage of caching in cases where a parent node refers to a child node that has already been refreshed (as exists in Power BI desktop today).
This issue creates significant performance problems with refresh times when creating highly interdependent financial and operational models. This is a show stopper from a usability and customer acceptance standpoint.
1,791 votesHi all,
I wanted to share with you that the new query caching mechanism in Excel has been deployed to Office Insiders starting from Excel version 1801 (build 9001.*). At this stage, we would like to allow some “baking” time as we monitor the feature health metrics.
In this scope, we need your help to ensure a quality release! I encourage you to try the following scenarios and share your feedback:
1. Run Refresh All on a complex workbook with multiple query dependencies. Does it work faster?2. Run Refresh All on a complex workbook with multiple query dependencies. Do you see any issues with your data?
3. Refresh a single query several times. Do you see any issues with your data?
- The Excel Team
-
Restore the pasting of tab separated text into columns from an HTML <pre> block and web data feed that has been removed from v16.0.7927.1020
When using data/from web or pasting a table from word or pasting an HTML <pre> block from a web page the tab separated data used to get automatically placed into columns. With v16.0.7927.1020 this has stopped - all the data goes into one column. There remains the option (checked by default) to do this when ingesting data from the web, but it no longer happens. When ingesting data from a web feed, you can't use the "paste as text" option to achieve this effect, so this change in behaviour has effectively broken our application's reporting facility. It still works in…
15 votesWe are aware of this issue and working on resolving in an update.
-
946 votes
Hi all,
We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey
Thanks!
Blake, Excel Product Team -
Maintain leading zeroes when entering values in cells
There should be an application setting OR paste recovery option OR cell format to retain leading zeroes when entering values in cells (either manually or through another means like CSV import).
(2015-11-05 Dan [MS] Updated idea title and description to broaden this issue from maintaining leading zeros on CSV data import to maintaining them on any cell entry.)
1,206 votesThanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.
- Urmi [Msft]
-
Stop Excel from changing large "numbers" (actually text values) to scientific notation.
Prevent Excel from changing large "numbers" (actually text values) to scientific notation.
1,350 votesThanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request.
- Urmi [Msft]
-
Add User Voice Button to Excel interface
To add a button to reach this page directly when there is a new idea to work on ... Ideas will come more fresh and easier to describe..
7 votesGreat news – we’ve started work on this.
The plan is to have a button under the File menu (something like File > Feedback > Submit Ideas for Excel) that will bring users here to UserVoice.
Cheers,
Dan [MS] -
QAT Spacing
The QAT spacing on the 2016 version is impossible to work with and forcing me to look at creating a new tab. I liked the spacing on 2013 which allowed me to view all my written macros and buttons. The new spacing pushed 5 of my buttons to a drop down. Please correct this spacing issue. The spacing does not need to be this large when you don't have a touch screen. I am one of 35 employees in my company that this effects. We have a customized QAT that all employees use.
72 votesThis one is getting underway – we’ve been channeling the feedback to the core team in Office that owns that UI, and they’re working on it!
Thanks,
John [MS XL] -
Make Power Pivot available in all versions of Excel
Previous title: "Make the Power BI Family - PowerPIvot + PowerQuery + PowerView and PowerMap available in all versions of Excel".
484 votesHi all,
I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.
We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.
Thank you for pushing for this!
Ashvini Sharma
PM Manager
Excel -
Enable collaboration with others editting in Excel desktop
In Word and PowerPoint you can collaborate from the desktop as well as online. In excel, whenever anyone opens the document on desktop others get locked out of editing and can only view. This is a problem for our organisation since occasionally remote team members need to edit the file on desktop but failure to close down the document properly (either accidentally or because the OS somehow did not release the file lock which has happened on Mac's) means the entire team is suddenly unable to work for extended periods until we track down the culprit.
266 votesHello All – If you haven’t already heard Coauthoring in Excel is live in production. In July we released co-authoring in Excel for Windows Desktop to all customers in our monthly (cc) current channel. Check out the details and the requirements for collaborating with others in the below support article and let us know how it goes. We’d love your feedback.
Thanks, Scott (Microsoft Excel PM)
- Don't see your idea?