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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 12:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com