optimizing excel work sheet
 

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

optimizing excel work sheet
 

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

"Jay" wrote in message
ups.com...
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

optimizing excel work sheet
 

Lost of great info here...

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

--
HTH...

Jim Thomlinson


"Jay" wrote:

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

optimizing excel work sheet
 

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
Jay
alondon wrote:
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

"Jay" wrote in message
ups.com...
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

optimizing excel work sheet
 

Thisworkbook.Calculate

--
HTH...

Jim Thomlinson


"Jay" wrote:

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
Jay
alondon wrote:
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

"Jay" wrote in message
ups.com...
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

optimizing excel work sheet
 

Thank you Jim,

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

regards
Jay
Jim Thomlinson wrote:
Thisworkbook.Calculate

--
HTH...

Jim Thomlinson


"Jay" wrote:

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
Jay
alondon wrote:
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

"Jay" wrote in message
ups.com...
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