Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoiding Calculating Cells on the Status bar
If the file size is big, any change made to the Excel file shows Calculating
Cells in %. and takes a lot of time to Complete this process. Is There any way to avoid this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoiding Calculating Cells on the Status bar
Tools - Options - Calculation and set to manual.
Hit F9 to force workbook to calculate. Mike "Satish" wrote: If the file size is big, any change made to the Excel file shows Calculating Cells in %. and takes a lot of time to Complete this process. Is There any way to avoid this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoiding Calculating Cells on the Status bar
Thanks Mike.
"Mike" wrote: Tools - Options - Calculation and set to manual. Hit F9 to force workbook to calculate. Mike "Satish" wrote: If the file size is big, any change made to the Excel file shows Calculating Cells in %. and takes a lot of time to Complete this process. Is There any way to avoid this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoiding Calculating Cells on the Status bar
if you have a lot of formulas which are not currently needed, copying and
paste special values over the top of them will open up the dependency tree. the thing that causes full recalc is the number of dependencies in the formula memories. for calcs which only have to be done occasionally but are the same for a column or row. leaving the first as a formula and pasting special on the rest will allow you to just copy and paste the formula over the range when you do need re calcs on some files I have set specific macros just to do cals on spcific columns. (you don't wnat to know how long it takes to do 52 columns by 60000+ rows of sumproduct calculations on 12 arrays 60000+ long) "Satish" wrote: Thanks Mike. "Mike" wrote: Tools - Options - Calculation and set to manual. Hit F9 to force workbook to calculate. Mike "Satish" wrote: If the file size is big, any change made to the Excel file shows Calculating Cells in %. and takes a lot of time to Complete this process. Is There any way to avoid this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Cells n% message in Status bar | Excel Discussion (Misc queries) | |||
autofilter calculating in Status bar | Excel Discussion (Misc queries) | |||
Avoiding empty cells showing as zero in line chart without na() | Charts and Charting in Excel | |||
AVOIDING DUPLICATES IN A RANGE OF CELLS | Excel Discussion (Misc queries) | |||
how do i copy formula down columns avoiding hidden cells | Excel Discussion (Misc queries) |