Forum Discussion
Microsoft .xlsm file long time to sync but pause & restart OneDrive it comes immediately
18MB is not a large file but is rather huge for a spreadsheet. I guess there are some big embedded objects (images?) in there.
The main angle to consider is the other users with write access to that file and the need to check that it is synched with their changes. If their machines are not responsive then your copy of the file will be affected.
Mike Williams Hi Mike, thanks for the response. There's no images in the file, its full of data. Its akin to a "Data Warehouse".
I think we trialled to see how it synced in the building and found its slow on multliple users OneDrive, but I would have to research that. I would also have to research if there are other big files that take a long time to sync, or is it just this one we happened to notice ?
Do you have some tests we could do to narrow it down, what's the cause ?
Pierino I confess I get chills seeing so much data inside a spreadsheet, rather than referenced through data queries to more robust stores. I've seen a **lot** of spreadsheet corruption issues in banking contexts. I know Microsoft used to exercise Excel on Wall Street spreadsheets but still...
With respect to the size, 18MB is not big - it's a handful of smart phone photos. I've synced multi-gigabyte files that are literally a thousand times larger.
If you have multiple devices syncing this file (particularly in a keep local copy scenario), then Excel has to martial all of them to check currency. It would only take one device with network or file contention issues to slow down everyone.
Other random thought: there is perhaps some "signature" that is being checked in the file XML and data that might be slowed by security algorithms - or even just the nature of it being a macro-enabled file triggers additional checks. (Multiply this across all copies of the file).See also: https://www.reddit.com/r/excel/comments/112ahmw/solution_enabling_macros_on_workbooks_from/
