Have I been sleeping on data validation lists, or was always just ignorant.

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,372

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Feb 13, 2023

• #11

That's on my Windows version.

I can't find any mention of this change in the Insiders blog or the normal Excel blog. Which seems daft to me as this is a great feature!

 

Upvote 0

awoohaw

Well-known Member

Joined

Mar 23, 2022

Messages

4,835

Office Version

1. 365

Platform

1. Windows
2. Web

• Feb 13, 2023

• #12

RoryA said:

That's on my Windows version.

I can't find any mention of this change in the Insiders blog or the normal Excel blog. Which seems daft to me as this is a great feature!

Click to expand...

I just figured out the place to find update dates. It looks like 2301 was in late January.

 

Upvote 0

awoohaw

Well-known Member

Joined

Mar 23, 2022

Messages

4,835

Office Version

1. 365

Platform

1. Windows
2. Web

• Mar 14, 2023

• #13

Okay, its been a minute since I posted this. Is anyone else now getting the automatically deduplicated data validation lists in Excel 365?

 

Upvote 0

Sufiyan97

Well-known Member

Joined

Apr 12, 2019

Messages

1,538

Office Version

1. 365
2. 2013

Platform

1. Windows

• Mar 14, 2023

• #14

awoohaw said:

Okay, its been a minute since I posted this. Is anyone else now getting the automatically deduplicated data validation lists in Excel 365?

Click to expand...

I am getting duplicate values in dropdown.

 

Upvote 0

awoohaw

Well-known Member

Joined

Mar 23, 2022

Messages

4,835

Office Version

1. 365

Platform

1. Windows
2. Web

• Mar 14, 2023

• #15

Sufiyan97 said:

I am getting duplicate values in dropdown.

Click to expand...

Have you updated your version of 365 recently?

 

Upvote 0

Fluff

MrExcel MVP, Moderator

Joined

Jun 12, 2014

Messages

90,849

Office Version

1. 365

Platform

1. Windows

• Mar 14, 2023

• #16

I thinks it's only available on the insiders channel. I'm on version 2302 on the monthly channel & don't have it.

 

Upvote 0

awoohaw

Well-known Member

Joined

Mar 23, 2022

Messages

4,835

Office Version

1. 365

Platform

1. Windows
2. Web

• Mar 14, 2023

• #17

Here is what I am still getting, and believe me. I am happy about it. I just don't know why Microsoft hasn't said much about it.

 

Upvote 0

awoohaw

Well-known Member

Joined

Mar 23, 2022

Messages

4,835

Office Version

1. 365

Platform

1. Windows
2. Web

• Mar 14, 2023

• #18

Fluff said:

I thinks it's only available on the insiders channel. I'm on version 2302 on the monthly channel & don't have it.

Click to expand...

I guess. But, I did not think insiders got beta versions. And, I am not that special of a person, although I've had my 365 subscription for quite a while.

 

Upvote 0

Sufiyan97

Well-known Member

Joined

Apr 12, 2019

Messages

1,538

Office Version

1. 365
2. 2013

Platform

1. Windows

• Mar 14, 2023

• #19

awoohaw said:

Have you updated your version of 365 recently?

Click to expand...

Actually, I am on office pc and updates are set to automatic so I don't do it manually.

 

Upvote 0

awoohaw

Well-known Member

Joined

Mar 23, 2022

Messages

4,835

Office Version

1. 365

Platform

1. Windows
2. Web

• Mar 14, 2023

• #20

Sufiyan97 said:

Actually, I am on office pc and updates are set to automatic so I don't do it manually.

Click to expand...

Okay, but you can check your version on your excel "account" page:
(So, I now have 2303) (I wonder what 'current channel preview" means, though).

 

Upvote 0