Forum Discussion
ong_bx
Nov 22, 2023Copper Contributor
Excel Issues - Power Pivot, Power Query, Automate
Hi I am facing these Excel issues, hope someone can help to solve them: 1) Power Pivot tab disappear. In Excel File > Options > Add-Ins > Power Pivot display under "Inactive Application Add-Ins"....
SergeiBaklan
Nov 22, 2023MVP
On which Excel platform/version you are and are you on business or consumer subscription if that's 365?
On modern Excel Power Pivot is activated from File->Options->Add-ins->COM add-ins
Power Query performance is very depends on how you structured queries.
Automate shall be on 365 for business subscribers only.
- ong_bxNov 23, 2023Copper Contributor
Thanks SergeiBaklan
Issued solved.
- SergeiBaklanNov 23, 2023MVP
ong_bx , you are welcome