Data Validation - Auto complete stopped functioning

wrose51106

New Member
Joined
Apr 10, 2022
Messages
4
Office Version
  1. 365
Platform
  1. Web
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?
 
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.
 
Upvote 0

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
@PeterBain as you already have a thread running on this, please stick to that rather than hijacking another members thread. Thanks
 
Upvote 0
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 :/
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top