WEBADI EXCEL file not working for data load.... ERROR " Run-Time error '1004': Method 'VBProject' of object'_Workbok' failed

WEB ADI EXCEL Opening File ERROR 

ERROR  " Run-Time error '1004': Method 'VBProject' of object'_Workbok' failed

Cause: MS Excel not enabled for trusted access to VBA Project Object Model

Error:

Solution:

Steps to resolve the issue:

1- Navigate to Excel sheet and Press Option tab

2- Click on Trust Center Tab

3- Click on Trust Center Setting

4- Click on Macro Setting Tab

5- Select the Enable all macros and check the box for Trust access to the VBAProject object model

6- Save the work to press ok and close and open Excel.