If you're editing a VBA macro in an Excel workbook stored in OneDrive, it temporarily stops syncing the workbook file and can cause sync conflicts where you lose all your changes. This has been an issue for years.

Nobody in their right mind wants to work with VBA. Spending all day hammering out a macro or function only to have it magically poofed out of existence is just cruel.

So now I store Excel workbooks (where VBA is involved) on my work pc and have a PowerShell script that copies them to OneDrive on a schedule as a backup.

I'm still amazed that corporations everywhere subscribe to this ridiculous circus.