Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, July 26, 2023
  1 Replies
  5.3K Visits
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
1 year ago
·
#3595
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)
1 year ago
·
#3612
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.