Anonymous
My feedback
-
1 vote1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Anonymous
shared this idea
·
-
85 votes5 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Thanks to RH for posting this suggestion. If avoiding #REF! errors is important to you also, please add your vote to support RH’s suggestion. We will prioritize accordingly.
Thanks,
Steve (MS Excel)Anonymous
supported this idea
·
-
101 votes85 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →Anonymous
supported this idea
·
-
114 votes15 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Good idea. We are definitely considering chart conditional formatting for a future release. Please continue to vote on it.
However, could you further elaborate on what you mean by “the value or content of the data labels”? Is the following scenario what you are looking for?
Scenario
Create a column chart that shows sales for various stores. (Sales on Y axis, Stores on X Axis.) Use color to represent the profitability of each store. Profit is a numerical value. (Bars in the chart show a gradient fill from green to red where green is high profit and red is low profit.)Thanks,
Scott [MSFT]Anonymous
commented
Folks, there's nothing happening in Excel Chart development. It appears that Power BI visuals will be the new charts in Excel.
-
120 votes7 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.
Cheers,
John [MS XL]Anonymous
supported this idea
·
-
126 votes5 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Anonymous
supported this idea
·
-
154 votes10 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion figboot. As always, we’ll prioritize this according to the number of votes it gets, so please be sure to vote it up if you want to see it done sooner.
Thanks
John [MS XL]Anonymous
supported this idea
·
-
171 votes11 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the post Charles, and for the in person conversation at the latest MVP conference. We definitely understand the ask and will keep our eye on it – it looks like it’s moving up the vote charts pretty quickly. As always, keep upvoting the things you are about most.
Best,
John [MS XL]Anonymous
supported this idea
·
-
194 votes13 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →Anonymous
commented
VBA is too ancient to waste any development time on improving it. At one time, I was sure that it would be upgraded to VSTA (with an appropriate PIA to speak to Excel), but that has never happened. With cloud computing coming into the picture, we need a replacement language that can work on all platforms, and that language might be JavaScript.
-
139 votes19 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
Hi all,
Yes, we’re considering providing R integration with Excel in the future, the number of votes on this item helps us gauge overall community interest in this, so please pull in others if you think they’d like this as well.
regards
ash [MS XL]Anonymous
commented
"Yes, we’re considering providing R integration with Excel in the future"
You're actually considering this? We can't even get the R.Execute function in Power Query, although it's just a matter of enabling the function.
Anonymous
supported this idea
·
-
200 votes18 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Hi Ken,
Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.
thanks
Ashvini Sharma
Lead Program Manager
ExcelAnonymous
commented
Makes no sense at all. After all, with Power Pivot, you can easily switch between Excel and the Power Pivot window. You can't even use another workbook while in the Power Query editor.
Anonymous
supported this idea
·
-
197 votes24 comments · Excel for Windows (Desktop Application) » 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
ExcelAnonymous
commented
"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."
Since so many Microsoft apps support Open R, R should be installed and managed in one location on every desktop. The installation can be done by Windows, Office 365, Power BI, SQL Server, whatever. When an app is run, it checks for the install and version, and install/update as necessary (including packages). For the Microsoft apps that support R, other instances of R installed elsewhere should be ignored.
Anonymous
supported this idea
·
Anonymous
commented
"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"
Hi Ash,
Perhaps R Open and associated packages should be installed with Office 365. Updates can be part of Office 365 updates. Then you can add the R.Execute function to M in Excel, which would allow folks to build cross-platform solutions using M & R.
-
225 votes22 comments · Excel for Windows (Desktop Application) » 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
ExcelAnonymous
supported this idea
·
-
369 votes27 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion! We’re fans of Regex and its ability to parse text too.
If you’d like to see Regex support in Excel, please keep the votes rolling in.
- JoeMcD [MS XL]
Anonymous
supported this idea
·
-
564 votes161 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.
Thanks,
Steve (MS Excel)Anonymous
supported this idea
·
-
594 votes60 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.
Thanks,
John [MS XL]Anonymous
supported this idea
·
-
675 votes110 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion Wyn! Thanks also to all the contributors to this thread for the thoughtful discussion and debate.
Of the many lookup function requests, this is currently one of the highest ranking on UserVoice. Please keep the votes rolling in if you’d like to see this, it helps us prioritize new feature work.
JoeMcD [MS XL]
Anonymous
supported this idea
·
-
698 votes108 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!
Thanks
Ashvini Sharma
Lead Program Manager
ExcelAnonymous
supported this idea
·
-
3 votes0 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →Anonymous
supported this idea
·
-
16 votes3 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →Anonymous
supported this idea
·
The proposed modification to the UNIQUE function and the addition of DISTINCT and TOPN are natural feedback suggestions with respect to the new and unreleased Dynamic Array functionality.