Hello.  I am running into this same issue.  We are using Quickbooks Premier Plus Non profit edition - 2022.  And I have Excel 365 running in 64 bit mode.  I get error 2147221000 and the "IRunningInstanceInfo" failed.

Interesting enough when the report is opened in Excel - excel goes into compatibility mode.  I don't know if that has anything to do with it - but even if I convert the spreadsheet out of compatability mode - the add-in fails with the same error.   Note also that I see the "QB SQL Anywhere" driver in both the 32 bit and 64 bit ODBC drivers.

If I were to download an update - what would I do - I don't see any choices for non-profit premier.

Please advise.