| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Speed up calculation of a worksheet that contains formula
In my file i am having formulae (about 52 columns), while copying the formula
the calculating cells take huge time. How to improve the speed? Vennilla. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Speed up calculation of a worksheet that contains formula
Turn the calculation to manual - then it will ONLY recalculate when you
want it to |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Speed up calculation of a worksheet that contains formula
Also, once the results are calculated, you can fix the values unless
you really want to keep the formulae - highlight all the cells with formulae in, click <copy then Edit | Paste Special | Values (check), OK, then <Enter. Hope this helps. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a Worksheet Reference Formula using a drop down box | Excel Discussion (Misc queries) | |||
| Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
| Updating formula with link to another worksheet using vlookup | Links and Linking in Excel | |||
| Cannat paste that macro formula onto a worksheet | Excel Discussion (Misc queries) | |||
| How do I get the formula to show the result on the worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
