View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Inserting new data before "calculating cells" is done???

One way is to set the calc mode to "Manual"
Click Tools Options Calculation tab Check "Manual" OK

Then when you're done with all the data entries, etc ..
just press F9 key to calc ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fecozisk" wrote:
Hi everyone! You guys have teached me so many things that now I have a new
problem...
My worksheet is so big that it takes a long time to recalculate everything
after inserting a new data. The problem is that I need to insert data faster
without changing my computer!
I'd like that excel let me move to next cell and insert new data on it
before it finishes calculating all cells. It doesnt matter to me that I have
a delay on the out data, but i need to insert data faster.
Calculating all after finishing my work does not solve my problem, because I
need some information live.

Thanks a lot!