How to maually calculate a range?

[Magnatolia]

Hi everyone,

I have a massive spreadsheet that auto-validates data from around 20 columns, utilising around 20 columns with advanced formulas, and about 20 named ranges.

What I'm wanting to do is streamline the processing of these as much as possible. Most are 1-4 columns per "category". I was considering setting the sheet to manual calculation. Can I then manually calculate the relevant columns? If yes, will these also calculate any other data sets they pull from, or will they calculate off the most recent calculations of those data sets?

Alternatively, can I prevent Excel from "freezing" and have the StatusBar show a custom % of all the calculations? Preferably without a macro, but maybe a macro on calculation?

Thanks!

 

[James006]

Hi,

This depends on the calculation mode you have selected ...

Take a look at following link : http://www.decisionmodels.com/calcsecretsg.htm

Hope this will help