Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Inefficient Calculation of User Defined Functions in Excel 2000

The problem I am having is that there is a bug in Excel 2K
that makes the excel recalculate UDF more times than
necessary (60 times). The problem was solved in Excel XP
but I need to run my functions in Excel 2K and with this
bug the performance is way too bad.

Has someone heard about a fix to this bug? Please let me
know if someone has info about this bug.

Thanks,

Leandro

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 968
Default Inefficient Calculation of User Defined Functions in Excel 2000

See
http://www.decisionModels.com/calcsecretsj.htm

hth
Charles Williams
www.DecisionModels.com

"Leandro Arias" wrote in message
...
The problem I am having is that there is a bug in Excel 2K
that makes the excel recalculate UDF more times than
necessary (60 times). The problem was solved in Excel XP
but I need to run my functions in Excel 2K and with this
bug the performance is way too bad.

Has someone heard about a fix to this bug? Please let me
know if someone has info about this bug.

Thanks,

Leandro



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
does Excel 07 allow User Defined functions? doc_grandma Excel Worksheet Functions 1 September 21st 09 11:16 PM
How to add user defined functions in excel permanantly Sandeep Jangra Excel Discussion (Misc queries) 2 October 10th 08 09:44 AM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM
I have had difficulty in creating user defined functions in Excel MichaelG Excel Worksheet Functions 3 July 13th 05 11:59 AM
Excel user defined functions. Matt Excel Worksheet Functions 4 March 15th 05 07:22 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"