View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fruitchunk fruitchunk is offline
external usenet poster
 
Posts: 35
Default Calculate Selected Cells Only?

I have a heavy excel workbook with lots of formulas, every time I did
something it was calculating literally for 20mins, so I changed it to Manual
Calculate. Now lets say I add a column and do calculate now it calculates the
whole sheet/workbook for a very long time. Can I tell it to only calculate
the new cells ? or maybe can I have excel calculate only selected cells?

Thanks