I seem to be losing files when developing an excel app using one drive. Am I alone?

Question

I am developing an Excel application that ingests many CSV files from OneDrive, Windows, and sometime, thumbdrives. Sometimes ingestion shifts to infinite amounts of time. What is happening?

Answer 1

Hi, Gerard Hallaren

This usually points more to OneDrive getting stuck processing a lot of cloud file changes than to Excel actually “losing” files, so the import can sit there forever or the files can seem missing on one device even though they still show elsewhere.

Here are some suggestions you can try:

First, keep your CSV intake folder outside the synced OneDrive folder while you build and test, then copy the finished files back afterward. If it works locally but hangs in OneDrive, that usually narrows it down to the sync layer, not your Excel app.

It is recommended that you sync only the folders you truly need during development, because performance problems can start once the total synced item count gets very high.

It is also suggested that you bring in CSVs in smaller batches instead of dropping a huge set in at once, since large bulk adds can leave OneDrive stuck on “processing changes” for a long time.

Thank you for your patience in reading, I hope this information has been helpful to you. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.