How to ensure everyone is running the same version of Excel?ģ. If possible, how do I determine the version of Power Query in Excel 2016?Ģ. I have updated my version of Excel 2016, updated a colleague's version of Office 2016 and still get this behavior.ġ. Iįind no way in Excel 2016 to update just the Power Query component.

I suspect different versions of Power Query are in play (mine versus that of my colleagues) however, given this is not a 365 updated product versus a stand-alone version, I would have thought they had the same update channel and would therefore match. Meanwhile, no error is produced if I eliminate, leaving just = Table.PromoteHeaders(bld_Sheet) and the headers are promoted as desired. In the version of Excel 2016 that my colleagues run, the following error is produced when this step is run upon workbook Refresh All: 2 arguments were passed to a function which expects 1 This step to promote headers works in my version of Excel 2016: = Table.PromoteHeaders(bld_Sheet, )

I did some nifty things with it and management decided to buy stand-alone Office 2016 for my 7 colleagues, so they could run my Power Query Excel 2016 workbooks.

I bought a stand-alone (non-365) version of Excel 2016 last year and love the Power Query feature.

Office 2016 power query