Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

Excel Issues - Power Pivot, Power Query, Automate

Copper Contributor

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".

In COM Add-Ins dialog box > tick on Power Pivot > Click Add, below screen shows up, what should I proceed?

ong_bx_0-1700649059607.png

 

 

2) Power Query respond time is slow.
Whenever a PQ table is loaded into Excel worksheet, it take a while to respond, please assist.

3) New Automate tab didn't show up in Excel.
In Excel File > Options > Customize Ribbon > Automate tab is seen here (see image below). But it is not shown up in Excel window, please assist.

ong_bx_1-1700649059611.png

 

Thank you!

 

Regards,
Ong, MY.

 

 

3 Replies

@ong_bx 

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

image.png

Power Query performance is very depends on how you structured queries.

Automate shall be on 365 for business subscribers only.

Thanks @Sergei Baklan 

Issued solved. 

@ong_bx , you are welcome