I am working on another computer that has Excel 2019. Importing data into Power Query/Power Pivot. Where can I find query settings? In previous versions it was an option on the ribbon. Now I only see File, Home, Design, and Advanced without an option to modify the ribbon.
Thank you for your help!
-Scott
Excel 2019 Power Pivot - query settings
-
scottb
- 4StarLounger
- Posts: 402
- Joined: 14 Apr 2010, 15:59
-
scottb
- 4StarLounger
- Posts: 402
- Joined: 14 Apr 2010, 15:59
Re: Excel 2019 Power Pivot - query settings
Please disregard. Found Power Query and I was looking in Pivot. Thanks.
-
HansV
- Administrator
- Posts: 78457
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel 2019 Power Pivot - query settings
Glad you found it.
For others reading this:
PowerQuery is now Get Data on the Data tab of the ribbon.
If PowerPivot is active, it should have its own tab on the ribbon.
You can activate PowerPivot using File > Options > Add-ins.
If PowerPivot is not listed near the top, under Active Application Add-ins, select COM Add-ins from the Manage dropdown near the bottom and click Go...
Tick the check box for PowerPivot and OK your way out.
For others reading this:
PowerQuery is now Get Data on the Data tab of the ribbon.
If PowerPivot is active, it should have its own tab on the ribbon.
You can activate PowerPivot using File > Options > Add-ins.
If PowerPivot is not listed near the top, under Active Application Add-ins, select COM Add-ins from the Manage dropdown near the bottom and click Go...
Tick the check box for PowerPivot and OK your way out.
Best wishes,
Hans
Hans