Is it good idea to run large VBA program in OneDrive?

I tend to save macro-enable workbook in local hard drive, since I believe that it will run much faster in local hard drive.

How about running the program when file is saved in OneDrive? Does it slow down a lot?

I don't really use OneDrive before, if I install OneDrive in every PC, does it make difference if you run macro in OneDrive folder vs. run macro in local hard drive folder?

One good thing to store file in OneDrive: I can have most current version of file in multiple device.

Thanks.

I believe that it will run much faster in local hard drive.

What is the basis for this?

The execution speed of VBA does not depend on where you opened the file from. The file is loaded into memory and all the work is done there no matter where the file is stored on disk.

However, if your file is in OneDrive and Excel is set for AutoSave it is possible that Excel is saving the file over the network as your code makes changes, which could take some time. I am not familiar with the internals of how Excel manages AutoSave, but I suspect it is a background process that would not slow down code execution. It would just use a little additional CPU and I/O time.

This explains how OneDrive syncs files: https://learn.microsoft.com/en-us/sh...t/sync-process

In all honesty, I don't know the answer. And I guess it would depend on several factors. I suspect that there could be a slight overhead if OneDrive is communicating changes to the cloud but one would hope it is optimised and the delay(s) would be minimal. If you are the only person using the file, I imagine the changes would be sent and, presumably, an acknowledgement received. If more than one person is using the file, then changes would need to be synchronised both (or multiple) ways.

I expect it would also depend on the efficiency of your code. If, for example, you read your data into an array and then process it in memory the changes to the actual data would not occur one at a time, but then the data would need to be updated.

Any processing would also be affected by anything else happening in your computer.

It should be easy enough to check. Put a timer routine into the code and then run it from both locations. Run the comparison several times to get an average time.

Follow up: I have a workbook that I use to track my energy bills (electric and gas). That file is in OneDrive so I can access it from all my devices. It is not using VBA but there are a lot of dynamic spill formulae. It is set to AutoSave. I can see, when I record new entries, that the file is saved immediately. There is no apparent or obvious delay in processing.