Excel 97 on Windows 2000

[Drhemlock]

I am running Excel 97 on Windows 2000, and need to make use of the Look Up Wizard.

Sadly, the Wizard Sub Menu, which should appear on the Tools menu, is not available when I am logged in to the Domain User. If I drop in to administrator, it is there, but I don't want users to be running applications from Administrator.

I know that the answer is probably a Registry edit. Fair enough. Question is..........what is it?

Any ideas, anyone?

 

[xlhelp]

Have you tried (under the user profile) going to Tools, Add-ins and see if Lookup wizard is checked?

Deja Moo - "I have heard that bull before"

 

[Drhemlock]

You know, sometimes things are soooooo obvious.......

Thanks, xlhelp, that worked. Why didn't I think of that?