| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating cells hangs when filtering ranges in a sheet
Hi, using Excel 2K3 herre. Is there any way that i stop the "calculating
cells" from happening every time i filter a sheet that a formula is referencing ranges on? It's getting stuck for long periods of time. Thank you, Mike |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating cells hangs when filtering ranges in a sheet
You could go to Tools | Options | Calculation (tab) and set the
calculation mode to Manual - this will speed everything up. If you need to recalculate (eg totals/subtotals after filtering) then press F9. It is a good idea to set it back to Automatic before saving the file. Hope this helps. Pete WiFiMike2006 wrote: Hi, using Excel 2K3 herre. Is there any way that i stop the "calculating cells" from happening every time i filter a sheet that a formula is referencing ranges on? It's getting stuck for long periods of time. Thank you, Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
| macro | Excel Discussion (Misc queries) | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Linear Mode
