A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
From your description, issue seems generating an excel report from accounting software not trigger the Excel software to be recognized as opened action.
You may create a shortcut for personal.xlsb or open a new workbook to open personal workbook as workaound.
Since it works normally for new workbook and exist workbook, I guess you need to find help from accounting software support to make it work.