Dear all,
I am a newbe on this forum, but far from newbe in Excel.
However, I face a problem I cannot tackle on my own.
I have a certain UDF which can be used, of course, in the cells. Think of it as somethin as: =myudf(A1;C4;"test") and it returns in the cell "success!" followed by the sum of both given cells. Of course, in reality, the UDF is quite more complex, but that does not really matter here I think. In my experience with Excel 2010, the UDF was only called when A1 or C4 was changed, or just before saving the file, and things like that. If i had multiple cells with this UDF, and all were pointing to different cells, only those UDFS who point to changed cells were updated. I could easily verify this by increasing a global variable with 1 everytime the UDF was called.
However, in Office 2013, as soon as i change 1 cell, all UDF's recalculate, even the ones not pointing towards that particular cell.
Also, in general, I experience that Excel 2013 is much, much slower when it comes to automatic cell-wise mutations than 2010: if i fill a large range of rows with a for loop it takes much, much longer. Is this a known problem?
Bookmarks