Share via

PowerQuery Add-In error 'Not Loaded. The user has selected to disable macros'

Anonymous
2016-01-21T05:48:15+00:00

Hello

When trying to activate the PowerQuery add-in (note there is a tick next to it but the PowerQuery tab isn't showing), the COM Add-ins box shows a message "Not Loaded. The user has selected to disable macros".

Note the following:

  • This was working fine 5 minutes ago.  The only thing I've done was click PowerPivot>Manage Data Model (no data model existed yet for this file).  
  • All macros are enabled 
  • I've tried re-starting Excel and the PC.
  • this happens on all files
  • I have tried re-installing Power Query and Excel
  • I've had this problem once before and the only solution was to re-install my windows profile (I don't want to do this again as it was very destructive).

Please help.

Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-01-21T18:08:42+00:00

    Hi,

    Welcome to Microsoft Community.

    Since the issue is related to Power Query, your issue would be better addressed in the Excel IT Pro forums:

    Click on the link below to post the query:

    http://social.technet.microsoft.com/Forums/en/excel/threads

    Thank you.

    0 comments