I want excel to automatically calculate some

January 31, 2011 at 19:11:55
Specs: Windows Vista
Is there some way to set excel to manually calculate certain cells, but automatically auntomatically calculate others? Specifically, I have one sheet with several (RANDBETWEEN) formulas that I want to calculate manually (only on command), while I still want every other formula in the sheet to calculate automatically. Is this possible?

See More: I want excel to automatically calculate some

Report •

January 31, 2011 at 21:06:27
The only way that I can think to do what you want is going to involve VBA code.

If you are open to trying that, give us a few more details about the RANDBETWEEN functions and how you are using them.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 2, 2011 at 11:44:47
The Randbetween formulas are used to generate a variety of different possible percentages (the equivalent of rolling dice), then there are dozens of depentent cells that generate calculations based upon the random numbers and data in other workbooks.
For example
C4=a perscribed numeric value
Often times I will need to copy the values from the 20th row and paste them into D29:D39 running total, without loosing sight of the value that had been gernerated simultaneously in D1.
Basically, I need cells D4 to R13 to generate numbers "on command", but I would like all other cells in all other worksheets to autocalculate as usual.
Does this help?

Report •

Related Solutions

Ask Question