Dé Céadaoin, Iúil 26 2023
  1 Freagraí
  Cuairteanna 3K
0
Vótaí
Undo
I'm using vs. 27.00.175
I have 3 Excel spread sheets that all use the DDL. The DDL consists of peoples names. On 2 of them I can add or delete names as needed and it automatically updates the DDL. However on the 3rd spreadsheet when I add or delete a name it doesn't automatically update the DDL. To get it to work properly I have to save the spreadsheet, close and reopen it in order to have it function properly.

Do you have any idea why this is happening?

Vince
mí 9 shin
·
#3595
0
Vótaí
Undo
Dia duit,

To better assist you, I have two questions:

1. On the third spreadsheet, is the default Excel dropdown list updating properly?
2. If the default dropdown list is updating correctly on the third spreadsheet, please take a screenshot of the data validation settings of the dropdown list and share it with us.
ddl.png

By confirming these details, we can pinpoint the issue more accurately and provide you with the appropriate solution.

Go raibh maith agat as do chomhoibriú agus do thuiscint.

Amanda
Ceangaltáin (1)
mí 9 shin
·
#3612
0
Vótaí
Undo
Dia duit ann,

Please try using the beta version of the software and check if the problem still persists: https://download.extendoffice.com/downloads/Kutools-for-Excel/beta/KutoolsforExcelSetup.exe

Please let us know if the problem occurs in the beta version or if it has been resolved. Your feedback is greatly appreciated.

Amanda
  • Page:
  • 1
Níl aon fhreagraí déanta don phost seo go fóill.