View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Choi Brian Choi is offline
external usenet poster
 
Posts: 1
Default How to avoid recalulcation (UDF)?

I made and use UDF (User-Defined-Function) which reads and brings data
from database through Internet. The UDF is included in my Add-In(XLA
format). My problem is that an Excel sheet which uses the UDF be
recalculated automatically whenever it is opened. I want to avoid
this recalculation without change Excel option to "Manual
Calculation".

please advise me the way to solve this problem.