PowerQuery Add-In Ribbon disapears

Hi,

Since the last PQ Update the PowerQuery and PowerPivot Add-In Ribbon disappears with increasing frequency. The troubleshooting (https://support.office.com/en-nz/article/Troubleshooting-Power-Query-2546eaa8-9893-4574-9ef9-afacb9b0b495) works, but it gets anyoing doing it 10 times a day.

In the past I had this problem from time to time. Maybe it's not related to the Update - I am a heavy PQ and Pivot User so maybe something else leads to this behaviour. 

Does anyone experience the same problems lately or does someone know what causes this problem?

BR


  • Edited by BerndSPL 18 hours 19 minutes ago
March 31st, 2015 9:20am

Hi BR,

Did you notice if Office moved the Power * add-ins to the disabled add-ins list?

This post may give you more context on the rationale behind this behavior.

Do you use Excel 32bits? Do you use large datasets?

Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 2:02pm

Hi Gil,

No, they do not appear in the disabled add-In List. They are removed from the ribbon List but in the COM-Add-Ins the are still checked.

My workaround is to uncheck them in the COM-Add-Inn List --> Close Excel --> Check them again and then the ribbons are back.

I am using 64bit Excel and the datasets are Web.Service Queries in PowerQuery with json files (some of them are about 80 to 100 MB)

BR,

bernd

April 1st, 2015 3:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics