Home

Complex Spreadsheet, very high disk usage working out of SharePoint directly

%3CLINGO-SUB%20id%3D%22lingo-sub-794013%22%20slang%3D%22en-US%22%3EComplex%20Spreadsheet%2C%20very%20high%20disk%20usage%20working%20out%20of%20SharePoint%20directly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794013%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20figure%20out%20what's%20the%20root%20of%20this%20issue%2C%26nbsp%3B%20but%20the%20gist%20is%20I%20have%20a%26nbsp%3B%3CEM%3Every%3C%2FEM%3Eformula%20heavy%20document%20that%20is%20currently%20misbehaving%20dramatically.%26nbsp%3B%20Co-authoring%20has%20gotten%20very%20flaky%2C%20not%20too%20surprised%20about%20this%2C%20the%20doc%20is%20slow%2C%20also%20expected.%26nbsp%3B%20What%20is%20perhaps%20most%20interesting%2C%20I%20am%20working%20directly%20through%20the%20SharePoint%20document%20library%26nbsp%3B%20instead%20of%20through%20OneDrive%20synced%20folders%2C%20and%20when%20attempting%20to%20%22save%22%20some%20large%20changes%20excel%20starts%20spinning%20at%20around%20~30%25%20CPU%20of%20a%20quad%20core%2C%20and%20constantly%20at%2030-50MB%2Fs%20disk%20activity!%26nbsp%3B%20This%20went%20on%20for%20well%20over%2010%20minutes%20then%20ended%20and%20the%20status%20changed%20from%20%22Saving%22%20to%20%22Saved%22.%26nbsp%3B%20I've%20no%20clue%20why%20there%20is%20so%20much%20disk%20activity%20for%20a%20file%20that%20is%20not%20even%20stored%20on%20my%20hard%20drive!%26nbsp%3B%20I%20assume%20excel%20is%20saving%20some%20temp%20files%20or%20something%2C%20this%20is%20expected%20but%20the%20file%20is%20not%20even%203%20MB%20in%20size!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20could%20excel%20possibly%20be%20doing%20that%20amounts%20to%20~18GB%20of%20disk%20activity!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-794013%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794699%22%20slang%3D%22en-US%22%3ERe%3A%20Complex%20Spreadsheet%2C%20very%20high%20disk%20usage%20working%20out%20of%20SharePoint%20directly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794699%22%20slang%3D%22en-US%22%3EI've%20no%20idea.%20But%20here's%20a%20couple%20of%20things%20to%20check%3A%3CBR%20%2F%3E-%20Download%20and%20run%20FINDLINK%20by%20Bill%20Manville%20(google%20for%20that%2C%20you'll%20find%20it%20easily)%20and%20run%20it%20to%20expose%20all%20hidden%20external%20links%20in%20the%20file.%20Get%20rid%20of%20the%20ones%20you%20know%20are%20faulty%3CBR%20%2F%3E-%20Check%20the%20Styles%20list%20(Home%20tab%2C%20gallery%20in%20the%20Styles%20section).%20If%20it%20contains%20a%20lot%20of%20them%20(check%20the%20same%20gallery%20when%20you%20open%20an%20empty%20workbook%20to%20compare)%2C%20you%20should%20remove%20the%20obsolete%20ones%3CBR%20%2F%3E-%20On%20the%20home%20tab%2C%20click%20the%20magnifyer%20and%20choose%20%22Selection%20pane%22.%20Then%20go%20through%20all%20worksheets%20to%20check%20if%20there%20are%20any%20unexpected%20objects%20on%20the%20sheets.%3C%2FLINGO-BODY%3E
Myles Gallagher
Contributor

I'm trying to figure out what's the root of this issue,  but the gist is I have a very formula heavy document that is currently misbehaving dramatically.  Co-authoring has gotten very flaky, not too surprised about this, the doc is slow, also expected.  What is perhaps most interesting, I am working directly through the SharePoint document library  instead of through OneDrive synced folders, and when attempting to "save" some large changes excel starts spinning at around ~30% CPU of a quad core, and constantly at 30-50MB/s disk activity!  This went on for well over 10 minutes then ended and the status changed from "Saving" to "Saved".  I've no clue why there is so much disk activity for a file that is not even stored on my hard drive!  I assume excel is saving some temp files or something, this is expected but the file is not even 3 MB in size! 

 

What could excel possibly be doing that amounts to ~18GB of disk activity!!!

1 Reply
I've no idea. But here's a couple of things to check:
- Download and run FINDLINK by Bill Manville (google for that, you'll find it easily) and run it to expose all hidden external links in the file. Get rid of the ones you know are faulty
- Check the Styles list (Home tab, gallery in the Styles section). If it contains a lot of them (check the same gallery when you open an empty workbook to compare), you should remove the obsolete ones
- On the home tab, click the magnifyer and choose "Selection pane". Then go through all worksheets to check if there are any unexpected objects on the sheets.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies