Shared Excel file on One Drive - is very slow

%3CLINGO-SUB%20id%3D%22lingo-sub-831795%22%20slang%3D%22en-US%22%3EShared%20Excel%20file%20on%20One%20Drive%20-%20is%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831795%22%20slang%3D%22en-US%22%3EHi%2C%20I%20save%20my%20data%20on%20One%20Drive%20and%20it%20works%20extremely%20smoothly.%20But%20when%20I%20work%20on%20Excel%20shared%20by%20my%20colleague%2C%20it%20works%20extremely%20slow.%20So%20much%20so%20that%2C%20it%20takes%20good%205%20minutes%20to%20open.%20Excel%20hangs%20and%20also%20crashes%20in%20between.%20Even%20small%20file%20size%20like%201%20MB%20takes%20time%20to%20load.%20And%20heavy%20files%20like%20of%2035mb%20(we%20save%20in%20.xlsb%20format%20to%20reduce%20the%20size%2C%20.xlsx%20size%20is%2068mb)%20makes%20us%20to%20pray%20God%20(lol).%20But%20same%20files%20work%20very%20smoothly%2C%20if%20I%20save%20that%20file%20in%20my%20One%20Drive.%20Can%20some%20one%20advice%20why%20it%20is%20so%20slow%3F%20And%20how%20to%20resolve%20it%3F%20Regards%2C%20TC%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-831795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOne%20Drive%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870627%22%20slang%3D%22en-US%22%3ERe%3A%20Shared%20Excel%20file%20on%20One%20Drive%20-%20is%20very%20slow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870627%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20sounds%20to%20me%20like%20your%20local%20system%20resources%20are%20very%20low%20-%20CPU%20and%20RAM.%3CBR%20%2F%3EIncrease%20the%20RAM%20to%20start%20with.%3C%2FP%3E%3CP%3EI%20would%20also%20recommend%20doing%20a%20backup%20of%20your%20system%2C%20formatting%20Windows%20with%20a%20fresh%20image%2C%20and%20reinstalling%20your%20Office%20Apps.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F401252%22%20target%3D%22_blank%22%3E%40Tarun2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
Hi, I save my data on One Drive and it works extremely smoothly. But when I work on Excel shared by my colleague, it works extremely slow. So much so that, it takes good 5 minutes to open. Excel hangs and also crashes in between. Even small file size like 1 MB takes time to load. And heavy files like of 35mb (we save in .xlsb format to reduce the size, .xlsx size is 68mb) makes us to pray God (lol). But same files work very smoothly, if I save that file in my One Drive. Can some one advice why it is so slow? And how to resolve it? Regards, TC
1 Reply
Highlighted

This sounds to me like your local system resources are very low - CPU and RAM.
Increase the RAM to start with.

I would also recommend doing a backup of your system, formatting Windows with a fresh image, and reinstalling your Office Apps. @Tarun2019