Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 26 July 2023
  1 Replies
  2.6K Visits
0
Votes
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
8 months ago
·
#3595
0
Votes
Undo
Hello,

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.

Thank you for your cooperation and understanding.

Amanda
Attachments (1)
8 months ago
·
#3612
0
Votes
Undo
Hi there,

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
There are no replies made for this post yet.