Data Validation - Auto complete stopped functioning

[wrose51106]

We have a shared workbook with data validation. Everyone uses Offie 365. Last week after someone messed with sheet protection, someone reported that auto complete stopped working in the data validation, it was rebuilt but no effect for the user. Now it has stopped for me, on all workbooks I create. Any idea where to begin?

 

[PeterBain]

It has, I think, been in and out of the Insider Beta, so will probably be a little while yet before it's available to desktop 365.

Thanks Rory,

Ill have to wait. Just a simple thing that would be perfect for something I'm building.

 

[Fluff]

@PeterBain as you already have a thread running on this, please stick to that rather than hijacking another members thread. Thanks

 

[PeterBain]

Sorry. I didn't know I was doing the wrong thing

 

[wrose51106]

I have been using it in Excel online. It has worked for months.

 

[wrose51106]

Thank you all for the comments, I can't help but feel I broke something.

Quick update, I have semi kinda fixed it? Clicking inside the data validation cell does not work. Clicking the drop-down arrow for the cell then typing does :/

 

[Fluff]

I can't help but feel I broke something.

I doubt it, MS have probably just made some changes.

 

[6StringJazzer]

Depends which version of Excel.

It's currently available in Excel Online.

I use 365 desktop and this is the first time I've seen a useful feature in the browser version that is not available in the desktop version.

I do not get the Insider Beta versions so was unaware of that but would generally not recommend that as a solution to a general audience.

 

[RoryA]

would generally not recommend that as a solution to a general audience

Nor would/did I.

The OP said he already had the feature but it had stopped working.

 

[Fluff]

I'm not on the insider/beta channel either & very rarely use xl online because of it's limitations, but was surprised to see that it was available.

 

[wrose51106]

How do I tell what channel I am on? I use web.