The files were all created in Office 365. Te problem happens with older files and current files. It is not consistent which filew will have a problem. There is not indication via OneDrive icons which files are problematic until I try to open them. After I try a red x shows in the icon position io file =e explorer. I've had trouble with at least 100 Office 365 files. No other files seem to be affected. Adobe, Quicken, Affinity, Finale, Photos and ToDIST all seem to work just fine, it's just Office 365 files.
I reinstalled Office 365 64 bit and checked to make sure that OneDrive is also 64 bit. The problem seems to be random. The very mysterious part is that when it happens with a file, Excel won't open it because it can't find it but Notepad can find it and open it just fine. So can Google Sheets (upload from my computer).
The file also opens just fine if I close OneDrive first. If I then open OneDrive while the file is open and save it, I get a message to reconnect it to OneDrive which seems to work okay but if I close the file and try to reopen it, Excel gives me the same error that it can't be found. Zapier can't find it either until I reset OneDrive.
Attached are the two error messages I get in Excel.
I tried to set up a Batch file to run OneDrive.exe /reset but it won'texecute that way. Besides, after the reset it take 8 hours for my two OneDrives to re-sync (one is a personal Microsoft account and the other is a Microsoft Business account).