When Excel 2003 formula is being calculated, can pre-saved excel be opened?
I am working with Excel UDF (written in C#, returns array result) which takes lot of time. When udf is running,I am not able to open any existing excel sheet.
I want to confirm, whether there is problem with my udf or excel behaviour is like this with all udfs (to maintain formula consistency)? Is this behaviour also persist with excel in-built formulas?
Code does not run in background. When code is running, generally you cannot perform other actions at the same time. This is not normally evident in running built-in functions because they're so fast, although this happens if a large, complex worksheet is being recalculated (i.e., hundreds or thousands of formulas being recalculated).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks