Red Squirrel
No Lifer
Is there a way through excel formulas to access AD? ex: I have a list of user names, so I want to put a formula to use the username (aka cell number) as a variable to get, say, the department, and put it in a cell beside it. Is this doable? I have an alternative way to do this with php, but I was thinking if I can do it directly in excell it would be cool as if the person changes department, it would change immediately on the spreadsheet. Downside would be the spreadsheet would have to be opened on the network (and probably on an account with domain admin access). I did some googling and did not find much on this, so I'm guessing there's not such AD integration in Excel, but though I'd ask anyway.