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?

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.

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

D1=RANDBETWEEN(1,20)

D4=RANDBETWEEN(1,100)%

D14='C:\Users\Public\[Performance.xlsx]Nadia'!$N$16*D5%

C4=a perscribed numeric value

D20=C20-(C20*D14)

D24=SUM(D29:D39)

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?

Ask Your Question

Weekly Poll