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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies