none
Power Query RRS feed

所有回覆

  • my version is 2.24.4065.1401

    And missing "Parameters" function

    2021年1月13日 上午 04:21
  • Hi, 

    From the versions of Office 2016, the Power Query is built into Excel, under Get & Transform. It's not a separate add-in like Power Query in Office 2013 and Office 2010. 

    If you need to update it, you need to update Office.

    Regards,

    Emily


    如果以上回復對您有所幫助,建議您將其“標示為解答”. 如果您對我們的論壇支持有任何的建議,可以通過此郵箱聯繫我們:tnsf@microsoft.com.

    2021年1月13日 上午 07:13
  • Hi,

    What's the version of your Office 2016?

    If you have volume licensed version, such as Office 2016 Professional Plus, you may install the latest updates from "Latest updates for versions of Office that use Windows Installer (MSI)".

    The following screenshot is taken from my environment with Office 2016 Professional Plus, Excel Version 16.0.4939.1000, and there is the "Parameters" group.

    If you have retail version, such as Office 2016 Professional, you may go to Excel > File > Account > Update Options > Update Now.

    Regards,

    Emily


    如果以上回復對您有所幫助,建議您將其“標示為解答”. 如果您對我們的論壇支持有任何的建議,可以通過此郵箱聯繫我們:tnsf@microsoft.com.

    2021年1月13日 上午 07:40