Some XLL add-ins will probably achieve a efficiency increase if they take under consideration the worksheet context that calls them. One example is, if a perform is termed from a sheet that is not at the moment active,
windows 7 starter 64 bit, and also the relaxation of the workbook doesn't have dependencies around the outcome the perform returns to that sheet – then the operate may possibly choose to skip its calculation. By doing this, only the calls within just the lively sheet truly take up compute time.
In order to do this optimization,
discount microsoft windows 7 x86, the XLL code needs to be able to query the sheet address of the cell from which it is called, and compare this to the energetic sheet ID. But finding out the calling cell’s sheet address was previously not possible. You could call xlfCaller,
office 2010 64bit key sale, but this perform would only return the calling cell address, without the cell’s sheet ID. So there was no way for you to decide if you wanted to skip your calculation.
To solve that, we added a new auxiliary perform that your code can call back into – xlCallerAddress. This purpose returns a reference to the calling cells. The reference contains the sheet ID on the calling sheet. You can then call xlSheetId to get the sheet ID of the active sheet,
genuine win 7 x64 key, and compare the two IDs. If they match,
win 7 enterprise activation, it means that your perform is being described as from the lively sheet.