Autocomplete for Data Validation

[melodramatic]

A few months ago, Autocomplete for Data Validation cells started working when Excel brought it up. Woot! A lifesaver to my regular routine of work.

However, yesterday, IT changed out my computer, and I am now without this function. When I asked our IT department, they didn't know what I was talking about. Meanwhile, everyone here at the office seems to have it except for me now.

What can I do to get this working on my laptop now? I'm going nuts!

BTW - the only thing I could find online was to make sure that this was checked: File / Options / Advanced / [Editing options] Enable AutoComplete for cell values. It is checked.

Thanks in advance for any help you can give me.

 

[Fluff]

Sounds like you don't have all the latest updates. What is the build version?

 

[melodramatic]

I've got Version 2308 (Build 16731.20600 Click-to-Run)

 

[Fluff]

In that case I would have thought you should have the new DV settings. Check what versions your colleagues are using & that they are on the same channel as you.

 

[melodramatic]

And this is why I always hate getting a new computer. 2 days in, and I'm still trying to get this one to work the way my old one did. <sigh>

Thanks for your help, Fluff.

 

[Fluff]

My pleasure.