How to avoid recalulcation (UDF)?

  • Thread starter Thread starter Brian Choi
  • Start date Start date
B

Brian Choi

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.
 
You have precluded a solution by saying no Manual Calculation.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Try something like setting a global switch in your XLA when it is opened and
in your UDF check the switch: the UDF either exits or does the DB retrieve.

--
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
 
Back
Top