open excel in calculation manual

[janeninca]

how does excel determine if it opens a file in manual or automatic?
how can i choose that excel opens every file in calculation manual?

regardsn
jan

 

[RoryA]

Rory - does that mean you could just use a purpose built add-in to change the calculation mode when you open up Excel? I don't suppose there's a registry hack to do this (switch calc to manual) is there?

Yes - I do in fact have one that does just that!

 

[Andrew Poulsom]

If you have a Book.xlt template and set calculation to manual while its open then save it, manual calculation will be the default provided that a blank workbook is opened when you start Excel.

 

[RoryA]

That may not work if you open files from Explorer without Excel already loaded, in my experience. That may be down to a setting in the registry though.