It has come to our attention that a recent Windows Update has been causing issues with F9 calculating in some versions of Excel 2016. If on calculate your previously working F9 spreadsheets are now returning #NAME, you may be affected.
Windows Update KB5002653 released November 12, is causing some issues with various Excel add-ins, including the F9v5.connect add-in. It is currently understood that it will only affect some specific Excel 2016 users.
Microsoft released an update on November 19th. If you are still receiving this error you should run the update or check here for more details:
November 19, 2024, update for Excel 2016 (KB4484305) - Microsoft Support