Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to setup Excel to do a manual re-calc on only one ( or only
specific ) worksheet(s)? I have a spreadsheet where one worksheet is a huge RNG. Another sheet holds converted data based on the random data and a third sheet takes real data which is input on a regular basis. The object of the program is to do what-ifs based on the differences between the random and real data. The problem is that the random data does not _HAVE_ to be re-genned everytime and the real data takes about 1 minute to enter, but then, to carry out the exercise, I have to wait an eternity whilst the RNG sheet re-calcs. TIA PITA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
calc | Excel Worksheet Functions | |||
My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
=If - how to tell it to calc certain %'s only | Excel Worksheet Functions | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions |