| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| Help Optimizing a Sheet to improve performance | Excel Worksheet Functions | |||
| extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
| GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
| Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
Linear Mode
