If you can’t sync a library, or prefer not to, you can pin the web location of a SharePoint form, media, or document library to your “Quick Access” panel in Windows Explorer.
This allows you to interact with (edit, replace, delete) the files just as you would in a network drive but requires that you’re connected to your SharePoint environment – there are no offline files in this method.
Access the library in Windows Explorer
Copy URL of library in SharePoint
Open Windows Explorer and paste in URL, deleting everything after the library name
Pin to Quick Access
You could then right-click “Quick access” on the left of Windows Explorer and select “Pin current folder to Quick Access” to bookmark it for next time
If you’ve seen a similar notification, I empathize with your pain. I don’t know that there is one solution to this problem, either, so I’m going to share a number of them we’ve used and hope that one (or all) of them will help you.
Basically a file is added through file explorer (a cloud library in OneDrive or SharePoint being synced locally to your computer) but then after a moment a notification appears which says “You now have two copies of a file; we couldn’t merge the changes in [filename]” and then the filename is appended with your computer name again and again until eventually the filename is too long and is harder to delete. Let’s not get to that point.