Avoiding Recalculation for a function in automatic mode

=?Utf-8?B?TG9rZXNoIFNoYXJtYQ==?=

Guest

Posts: n/a

18th Sep 2006

I got 2 functions in my Excel func1 and func2 and its running in automatic
mode. Since my excel i s running in automatic mode, both functions are called
again and recalculated.
I would like to avoid recalculating of func1 but would like func2 to
recalculate again.

Is there a way for this?? Since when I set EnableCalculation = True , both
functions are called.

« Isolating mailadresses | what is a coupon rate and ytm of a bond? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
keep manual recalculation mode on	Greg	Microsoft Excel Worksheet Functions	2	26th Jan 2010 03:43 PM
Avoiding a range in recalculation	=?Utf-8?B?RkNT?=	Microsoft Excel Programming	3	20th Sep 2007 06:22 PM
RECALCULATION won't stay set to automatic	=?Utf-8?B?RHJld0BFSQ==?=	Microsoft Excel Crashes	1	28th Sep 2006 05:49 PM
Avoiding Recalculation for a function in automatic mode	=?Utf-8?B?TG9rZXNoIFNoYXJtYQ==?=	Microsoft Excel Worksheet Functions	2	19th Sep 2006 04:52 AM
Manual/automatic recalculation	rt0029py	Microsoft Excel Discussion	2	27th Jan 2005 11:06 PM