[Excel vba] Excel does not respond to export for too long when using OneDrive service

%3CLINGO-SUB%20id%3D%22lingo-sub-2267149%22%20slang%3D%22zh-CN%22%3E%5BExcel%20vba%5D%20Excel%20does%20not%20respond%20to%20export%20for%20too%20long%20when%20using%20OneDrive%20service%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2267149%22%20slang%3D%22zh-CN%22%3E%3CP%3EVersion%3A%20office365%2C%20using%20Microsoft%20OneDrive%20for%20collaborative%20development.%20I%20wrote%20an%20output%20processing%20table%20locally%2C%20and%20the%20running%20time%20was%2025%20seconds.%20%3CBR%20%2F%3E%20In%20the%20OneDrive%20directory%2C%20the%20running%20time%20reached%20more%20than%20300%20seconds.%20In%20the%20task%20manager%2C%20it%20was%20found%20that%20excel%20would%20not%20respond%20every%20certain%20period%20of%20time%20when%20running%2C%20resulting%20in%20a%20very%20long%20overall%20output%20time.%20%3CBR%20%2F%3E%20Ask%20the%20big%20guys%2C%20what%20is%20the%20reason%3F%20Do%20I%20need%20to%20disable%20any%20function%20of%20OneDrive%20in%20excel%20when%20exporting%3F%20I%20am%20very%20grateful.%3C%2FP%3E%3CP%3E(The%20auto-save%20function%20has%20been%20turned%20off%2C%20but%20it%20has%20no%20effect)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2267149%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Version: office365, using Microsoft OneDrive for collaborative development. I wrote an output processing table locally, and the running time was 25 seconds.
In the OneDrive directory, the running time reached more than 300 seconds. In the task manager, it was found that excel would not respond every certain period of time when running, resulting in a very long overall output time.
Ask the big guys, what is the reason? Do I need to disable any function of OneDrive in excel when exporting? I am very grateful.

(The auto-save function has been turned off, but it has no effect)

0 Replies