303 votes87 comments · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
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.
1,968 votes281 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
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
FWIW, I don't see anything in the release notes about this in version 1801 build 9001.x
Some additional info on how to check/verify/change update channels.
To find your Office 365 Version
Information on Update Channels
Article about how to switch channels if your settings allow it
I've done this on my machine at work to get to the Monthly release channel while most of my colleagues remain on the Semi-annual Channel (Targeted)
375 votes8 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]