Excel Sheet Calculating despite being in manual mode

%3CLINGO-SUB%20id%3D%22lingo-sub-807318%22%20slang%3D%22en-US%22%3EExcel%20Sheet%20Calculating%20despite%20being%20in%20manual%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807318%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Im%20working%20with%20a%20large%20file%20that%20keeps%20freezing%20up%20to%20%22calculate%22.%20I%20have%20my%20options%20set%20to%20%22manual%22%20with%20the%20%22recalc%20when%20saved%22%20box%20unchecked.%20Any%20idea%20how%20I%20can%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-807318%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1484182%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sheet%20Calculating%20despite%20being%20in%20manual%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484182%22%20slang%3D%22en-US%22%3E%3CP%3EI%20realise%20this%20is%20an%20old%20posting%20but%20for%20future%20reference%20here%20is%20a%20thought%20(I%20run%20into%20this%20all%20of%20the%20time)%3A%3C%2FP%3E%3CP%3Emake%20certain%20you%20set%20recalc%20to%20manaul%26nbsp%3B%3C%2FP%3E%3CP%3Ereset%20recalc%20before%20save%20to%20manaul%20(unchecked)%3C%2FP%3E%3CP%3Eset%20%23%20of%20processors%20to%20less%20than%20you%20have%20or%20excel%20will%20consume%20all%20resources%20and%20will%20be%20difficult%20to%20stop.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20large%20spreadsheets%20that%20often%20require%20hours%20to%20do%20a%20full%20recalc%20and%20the%20above%20solves%20my%20problem.%20Until%20...%20someone%20else%20opens%20the%20file%20and%20then%20saves%20it.%20in%20which%20case%20the%20settings%20get%20changed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20yet%20to%20identify%20any%20setting%20that%20always%20forces%20all%20excel%20workbooks%20to%20never%20recalc%20unless%20explicitly%20requested.%20it%20always%20wants%20to%20%22help%22%20be%20defaulting%20to%20auto%20recalc%20which%20can%20break%20some%20workbooks%20if%20they%20reference%20other%20files%20which%20may%20not%20be%20available.%20and%20often%20sets%20my%20pc%20up%20to%20be%20consumed%20by%20the%20recalc%20process.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374321%22%20target%3D%22_blank%22%3E%40csu94%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Im working with a large file that keeps freezing up to "calculate". I have my options set to "manual" with the "recalc when saved" box unchecked. Any idea how I can fix this?

1 Reply

I realise this is an old posting but for future reference here is a thought (I run into this all of the time):

make certain you set recalc to manaul 

reset recalc before save to manaul (unchecked)

set # of processors to less than you have or excel will consume all resources and will be difficult to stop.

 

I use large spreadsheets that often require hours to do a full recalc and the above solves my problem. Until ... someone else opens the file and then saves it. in which case the settings get changed.

 

I have yet to identify any setting that always forces all excel workbooks to never recalc unless explicitly requested. it always wants to "help" be defaulting to auto recalc which can break some workbooks if they reference other files which may not be available. and often sets my pc up to be consumed by the recalc process.@csu94