Wyn Hopkins
My feedback
-
100 votes18 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment An error occurred while saving the comment Wyn Hopkins
commented
Great idea
Wyn Hopkins
supported this idea
·
-
28 votes2 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
For those without the connector you can copy this code and paste it into the Power Query Advanced Editor and then adjust the URL
ONEDRIVE FOR BUSINESS
let
MainOneDriveFolder = "https://YourCompany- my.sharepoint.com/personal/Yourname_company_com",
Source = SharePoint.Files(MainOneDriveFolder, [ApiVersion = 15])
in
SourceSHAREPOINT
let
MainSharePointFolder = "https://YourCompany.sharepoint.com/YourOptionalSiteName",
Source = SharePoint.Files(MainSharePointFolder, [ApiVersion = 15])
in
SourceYou could also swap out SharePoint.Files for SharePoint.Contents in order to navigate through shared documents and sub folders (and potentially faster refreshes)
Wyn Hopkins
shared this idea
·
-
368 votes28 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Thanks everyone for showing a lot of passion about Dataflows data connector in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.
Guy Hunkin
Principal Program Manager
Excel TeamAn error occurred while saving the comment Wyn Hopkins
commented
The new Power Query Rich Data Types functionality should be added here also rather than via the “featured table” option in Power BI
Wyn Hopkins
supported this idea
·
-
84 votes10 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
Agreed, just show the expanded box
Wyn Hopkins
supported this idea
·
-
129 votes24 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
- expands and indents with Shift Enter
- allow comments
- can be detached and floated
- formula can be named ( for lambdas)
- allow auto expanding of formula bar to be turned off and on easily
- colour coding when referencing variables
-Wyn Hopkins
shared this idea
·
-
43 votes12 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →Wyn Hopkins
supported this idea
·
An error occurred while saving the comment Wyn Hopkins
commented
The Current Channel version now allows referencing to the cells in a Table column ( and the validation picks up the new items ) https://youtu.be/MD_iLh-UEmQ
-
115 votes14 comments · Excel for Windows (Desktop Application) » Product Setup and Activation · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
Gets my vote
Wyn Hopkins
supported this idea
·
-
258 votes
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]An error occurred while saving the comment Wyn Hopkins
commented
Here's a link to the current 2 workarounds. Neither is very satisfactory https://youtu.be/igcCbKqtwrk
Wyn Hopkins
shared this idea
·
-
22 votes1 comment · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Wyn Hopkins
supported this idea
·
-
63 votes0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
We’d like to see how many votes this gets as a way to help us prioritize the work. Thanks!
Wyn Hopkins
supported this idea
·
-
30 votes5 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
This would be fantastic
Wyn Hopkins
supported this idea
·
-
264 votes19 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]An error occurred while saving the comment Wyn Hopkins
commented
I definitely want it to expand automatically while typing or editing. I’m thinking that just selecting a cell with a multi row formula would cause an indicator (expand icon) to appear next to formula bar
Wyn Hopkins
supported this idea
·
An error occurred while saving the comment Wyn Hopkins
commented
This becomes even more important now that the LET function is being introduced
-
5 votes1 comment · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
Even better add a Power Query Connector : From File on OneDrive / SharePoint
Wyn Hopkins
shared this idea
·
-
10 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Wyn Hopkins
supported this idea
·
-
52 votes19 comments · Excel for Windows (Desktop Application) » Collaboration and Sharing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
Yep, voted, see this same thread also https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10635309-ability-to-comment-within-formulas
Wyn Hopkins
supported this idea
·
An error occurred while saving the comment Wyn Hopkins
commented
The syntax // is used for DAX and Power Query to comment out code
Would be great to have that in Excel too
-
19 votes0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →Wyn Hopkins
supported this idea
·
-
349 votes14 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Hi all,
Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.
Thanks,
Guy Hunkin
Excel Program ManagerAn error occurred while saving the comment Wyn Hopkins
commented
That's a shame Guy, thanks for letting us know though.
Any chance you can add this link (to Ken's post) to your response as a workaround:
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/Wyn Hopkins
shared this idea
·
-
305 votes33 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Wyn Hopkins
commented
This is a great idea for Dynamic Arrays. Optional parameters covering:
split at left most / right most delimiter
Number of splitsWyn Hopkins
supported this idea
·
-
135 votes11 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Wyn Hopkins
supported this idea
·
-
17 votes6 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Wyn Hopkins
supported this idea
·
An error occurred while saving the comment Wyn Hopkins
commented
Mynda Treacy's video demo's the issue nicely here
https://youtu.be/2ViMm-wuM3U?t=561
Should also happen when using Power Query to get data from a sheet so that you don't need to fix up Power Query later after you change the name of the Table