It would be great if we had a simple button to grab a parameter from a named cell

Please vote for this

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32691571-add-get-parameter-button-to-power-query-and-avoid

 

Plus it should ignore the Privacy settings for these types of queries.  i.e. no more Formula.Firewall warnings.