Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting new data before "calculating cells" is done???
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting new data before "calculating cells" is done???
thats a way out... but not ecxatly what i thoght...
I'm analysing a soccer match with my worksheet, so i never stop adding information to it. The problem on you method is that I always need to view the informations DURING the match. So i may not be able to wait excel to calculated all cells after pressing F9 (because the match will restart at any minute and excel probably would take a long time to calculate everything, right? thank you anyway! but i'll still looking for another alternative! "Max" escreveu: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting new data before "calculating cells" is done???
No prob.
Perhaps try Charles William's: http://www.decisionmodels.com/calcsecretsg.htm would have something relevant for you Also, hang around awhile for possible insights from others .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Fecozisk" wrote: thats a way out... but not ecxatly what i thoght... I'm analysing a soccer match with my worksheet, so i never stop adding information to it. The problem on you method is that I always need to view the informations DURING the match. So i may not be able to wait excel to calculated all cells after pressing F9 (because the match will restart at any minute and excel probably would take a long time to calculate everything, right? thank you anyway! but i'll still looking for another alternative! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Inserting additional data into an existing cell? | Excel Discussion (Misc queries) | |||
inserting rows through external data source | Excel Discussion (Misc queries) |