Its time for me to give up on Office, mostly because of how frustrating OneDrive is. I think its functional but annoying on windows but I've had so many headaches on the Mac. Then there's MS desire to report everything do, for their AI, or selling it to the highest bidder.
I just manually downloaded all of my files from OneDrive, copied it to a new drive, and I'm about to delete OneDrive from my Mac, and install Libre Office.