optimizing excel work sheet

[Jay]

hi

i have excel work book containing more than 10 worksheet , each
worksheet cell is interconnected with formula

its taking ages to calculate each cell , and when i make a data entry
its taking ages to go to another cell when i press TAB

is there any way to optimize the excel sheets and speed up the process

thank you in advance

Regards
Jay

 

[alondon]

Jay,

Go to Tools|Options!Calculation and set calculation to Manual. When you
have completed your data entry simply type F9 to calculate. If you have
UDF's, you had better type Ctrl-Alt-F9. That's it.

APL

 

[Guest]

Lost of great info here...

http://www.decisionmodels.com/index.htm

 

[Jay]

Jim
thank you for the reply,

is there any macro to do the update i.e F9 function ? when i click on
update button it should do the work of F9
cos as this excel is distributed to many people

thank u
regards

 

[Guest]

Thisworkbook.Calculate

 

[Jay]

Thank you Jim,

Can you give me full vba code cos i m new to vba ?

regards
Jay