mikecroom
New Member
- Joined
- Oct 8, 2010
- Messages
- 47
I am using the function GetAdsprop from Query Active Directory from Excel. I have it stored as an Add-In.
I have a long column of Windows IDs and use GetAdsprop to get the associated email address of each one. Each lookup takes quite a long time.
Every time I change the filtering all of the GetAdsProp seem to recalculate.
Can anyone explain to me the rules for when filtering triggers a recalculation and whether it is possible to avoid it.
I have no volatile functions that I know of and GetAdsProp does not declare itself as volatile
I am on Excel 2007 in this instance
Mike
I have a long column of Windows IDs and use GetAdsprop to get the associated email address of each one. Each lookup takes quite a long time.
Every time I change the filtering all of the GetAdsProp seem to recalculate.
Can anyone explain to me the rules for when filtering triggers a recalculation and whether it is possible to avoid it.
I have no volatile functions that I know of and GetAdsProp does not declare itself as volatile
I am on Excel 2007 in this instance
Mike