prevent recalculation of random data except in a "Calculate" macro

  • Thread starter Thread starter matt dunbar
  • Start date Start date
M

matt dunbar

Hi

is there a way to prevent recalculation except in a "Calculate" macro

i am turning on and off data in a chart by using a 1 or 0 multiplier on
the data

However this data is randomly generated so if i change this multiplier
value to 1 or 0 the random data updates also which i do not want

However i will make the data changet change but only by firing a macro
with a "Calculate" statement in a separate macro

thanks

matt
 
Set in Excel in menu Tools - Options - Calculation the
calculation to Manual instead of Automatic.

Regards
Klaus
 
Have you gone to tools=>Options, then the calculation tab and set
calculation to Manual?
 
Back
Top