| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet.Calculate limits??
Hello, I have a macro that does the following (Excel 2000): Sheets("MySheet").select ActiveSheet.EnableCalculation = False <Write 1000's of v-lookup formulas in sheet <e.g. i have one instance with ~ 12000 formulas ActiveSheet.EnableCalculation = True ActiveSheet.Calculate <Overwrite all formulas with values through copy & paste-values commands... The problem: the last 20-30 rows (about 400-600 formulas) do not calculate before the code proceeds with the overwrite. How can this happen? How can it be fixed? Thanks, Luz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross-sheet dependencies (smart recalc limits) | Excel Discussion (Misc queries) | |||
| SUM 3D Reference using variable sheet limits | Excel Worksheet Functions | |||
| F9 vs. Calculate Sheet | Excel Worksheet Functions | |||
| VLOOKUPS: Limits on # per sheet? | Excel Discussion (Misc queries) | |||
| Using UsedRange as limits in a For Each loop but for cells on another sheet ? | Excel Programming | |||
Threaded Mode
