prevent recalculation of random data except in a "Calculate" macro
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
prevent recalculation of random data except in a "Calculate" macro
Have you gone to tools=Options, then the calculation tab and set
calculation to Manual? -- Regards, Tom Ogilvy "matt dunbar" wrote in message ... 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 05:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com