448 votes72 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
381 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]
Having regex capabilities would dramatically simplify a lot of the daisy-chaining of M functions or Excel functions I have to string together as well as providing capabilities that I can't even achieve (or don't know how to achieve) with current methods.
I hope that if/when you implement regexs that you consider a flavor that supports positive and negative lookbehinds and lookaheads.
366 votes109 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
Thank you for your input on Excel’s filepath limit! We have included this feature as part of upcoming work.
David [Microsoft Excel]
I've had an issue the past couple of months where occasionally I'm unable to use the Modern Copy interface in SharePoint online (link here: https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Announcing-File-Copy-Move-for-SharePoint-Modern-Document/ba-p/4884) to copy some spreadsheets over to another library. I get a really lousy and unhelpful error of "1 item wasn't copied". https://www.screencast.com/t/PEc6XaXJaC In finding a Excel 2017 and Excel 2010 article about this limitation I figured, "What the heck? Why not try it?" and lo and behold, by reducing the directory name in SharePoint Online by a few characters, it fixed the issue! I too am shocked that in today's day and age that this is still a limitation. (Literally the file is only 2 folders deep.) It is even trickier to troubleshoot when there is nothing in SharePoint Online to indicate that this was the limitation that was experienced.
6 votes2 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
I REALLY wish we had this. It would allow me to create reports that are much more valuable and useful to our company. Ultimately, I wish that Hyperlinks would become first-class citizens in the Excel PowerPivot data model as well by allowing calculated columns to use the Hyperlink function.
This is one of those areas where I feel Excel is almost there. Since I believe usage cases are more motivating, I'm including an example of a report I've recently written that can be viewed via the hyperlink below. (I've trimmed it a bit and anonymized the information.) The report shows card records from Trello grouped by the email address of the person for whom we're doing some work. I'm able to do almost everything I want in Excel including using Power Query to dynamically pull the data from Trello via the API, group it together by both Card and Checklist, and give a report for those checklist items that are still due. It's so close to being valuable to people over our current process, however, being able to quickly give the person a hyperlink to click to complete the task is both more readable and actionable than trusting them to copy and paste a URL from the report.
393 votes9 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!
ash [MS XL]