Microsoft .xlsm file long time to sync but pause & restart OneDrive it comes immediately
I have a big xlsm file (18mb) which a user updates on a daily basis.
It doesn’t come onto my OneDrive for a considerable amount of time, it was timed at 23 minutes today, I don’t have other historical times. OneDrive says “Your files are synced”.
However, if I pause and restart OneDrive, the file comes immediately.
My IT Support don’t know why this is happening and they have removed OneDrive & re-installed, reset OneDrive and they think its some combination of being a large file and/or being a Microsoft Macro-enabled workbook, so xlsm. It has to be a Macro-enabled workbook as it does stuff with external data and puts it into a certain format, via VBA code.
Anyone seen something like this before ?
I have a big xlsm file (18mb) which a user updates on a daily basis.It doesn’t come onto my OneDrive for a considerable amount of time, it was timed at 23 minutes today, I don’t have other historical times. OneDrive says “Your files are synced”.However, if I pause and restart OneDrive, the file comes immediately.My IT Support don’t know why this is happening and they have removed OneDrive & re-installed, reset OneDrive and they think its some combination of being a large file and/or being a Microsoft Macro-enabled workbook, so xlsm. It has to be a Macro-enabled workbook as it does stuff with external data and puts it into a certain format, via VBA code.Anyone seen something like this before ? Read More