an unexpected error occurred: External component has thrown an exception

Excel is giving the error "An unexpected error occurred:  External component has thrown an exception" when opening a Sage 50 US Sage Intelligence Financial Designer report. What is causing this and how to fix it?