ArcGIS for Excel Issue, "Show Map" Grayed

Really trying to cast a wide net so I apologize if this is an r/LostRedditor situation.

I use ArcGIS for Excel as part of a routing workflow. I've use it as a guest. There's about 20 workbooks that are almost identical (data differs, formatting and UDFs are identical) that have a couple UDFs but are by and large quite simple (Store Numbers, Lat/Lon, etc.). They are all saved to my company's OneDrive

About a week ago, I just lost the ability to "Show Map" as pictured. In very isolated scenarios the add-in has worked upon opening, but the only solution I've found thus far to resolve the problem is to completely remove the add-in, reinstall it, then open the workbook. This works precisely ONE time before the show map icon is grayed again. If I close the workbook and immediately re-open it, it will be grayed until I repeat the remove/reinstall.

Things I've tried (not in order):

• A wild goose chase ChatGPT sent me on messing with my DNS, cached data, and a miriad of other things. None of which worked...obviously
• Wiping and reinstalling Microsoft Office from my computer
• Saved .xlsm as a .xlsx
  • Moved the files to local storage, then repeated the above