| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculation
I have a macro that is inserting lines on 2 sheets in another workbook. The
other workbook has 10 sheets. 1 sheet contains the data and the other 9 sheets contain many formulas that are all inter-connected with the various sheets. The lines are inserted in the data sheet and in 1 of the other 9 sheets. The other 8 sheets are not changed at all The problem is when I insert a row on either of the 2 sheets, it takes forever. I have tried changing calculation to manual and then turning it back on to automatic when I'm done running the code but that doesn't seem to help. I would appreciate any suggestions to speed up the row insertion process. Thanks for your help...... -- JT |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
| PMT Calculation | Excel Programming | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| range.calculation with UDF not working when calculation is set to automatic | Excel Programming | |||
Threaded Mode
