Could you please share us which version of Office are you using now?
Will the local workbooks opended as blank if you open them in Excel app?
I suggest you temporarily move the macro file and other startup items from Startup folder (Such as Microsoft Office Professional Plus 2016,
C:\Program Files\Microsoft Office\Office16\XLStart ,
C:\Users\<User Name>\AppData\Roaming\Microsoft\Excel\XLSTART ) and disable Excel COM add-ins to check this issue.
Please also go to File > Options > Advanced, under General part, ensure "Ignore Other Applications that use Dynamic Data Exchange (DDE)" is unticked.
Any updates, you may post back.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.