This issue can be caused when the powerOLAPExcel.ini file is present

Solution:

1. Navigate to Windows(C:) > Windows >System32

2. Locate a file called PowerOLAPExcel.ini

3.Rename or delete this file
4.Refer to manually installing add-ins to get add-ins working again