The issue seems to be that QB won't work with the 64bit version of  desktop office 2019. I had to uninstall my 64 bit version of office and install the 32 bit version. After the 32bit version was installed the programs once again talked to each other in terms of the ability to export reports.  I am running QB 2020, 2019 & 2018.

The "refresh a report" function is still not there. There is no QB Add-in tab in excel 2019.  I guess I am going to have to grit my teeth and learn statement writer. I hope that works. However, this is a nice to have not a need to have function for me.

Beware. The switch off from 64 to 32 bit office did not go smooth. The 64 bit version  didn't let  go completely so when I tried to install the 32 bit version it said the 64 bit version was still there. Trip down to the Microsoft store. Thank God I had moved my business to Laptop. The techs there had flash drives full of special "tools" so apparently the uninstall of 64 to move to 32 is a known issue. Two different techs worked on the issue for about 3.5  hours without success. They had to escalate the issue and a senior techie remoted in the next day. She worked on the issue for about an hour and was able to get the 32 bit program up and running.  Fortunately, Microsoft does not charge for this service which I was elated to discover.