EXCEL dropdown autocomplete function not working when copied to another PC

Question

EXCEL dropdown autocomplete function not working when copied to another PC

Alan Ramsden 20

I created a dropdown on a worksheet based on a column of data in a separate worksheet. The updated autocomplete function (see version 2308) works fine but when a copy of the workbook is copied to use on another PC, the autocomplete function does not work. Both PC's are operating on the latest version of EXCEL and all worksheets are present on both systems so I can't really understand why this anomaly is occurring. Anyone got any ideas?

Accepted answer

0 additional answers

Your answer

Answer 1

Emi Zhang-MSFT 30,046 Microsoft External Staff

Hi,

I suggest you check if the problem user use the Current Channel for Excel. Please go to File- Account:

User's image

AutoComplete for Data Validation drop-down list is available in Current Channel with version 2306, build 16.0.16501.20004 or later.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Alan Ramsden 20 Reputation points

2024-03-31T08:36:41.9733333+00:00

The problem seems to lie within the original software package on the second PC. Started out as Microsoft Office Professional 2021 and although the build/release levels looks ok the dropdown autocomplete won't work in the same way. May have to uninstall and reinstall with Microsoft 365.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2024-04-01T07:22:41.4533333+00:00

It is possible that your computer contains some other versions of Office product keys, and you can try to check the status of the product keys on your computer, please follow these steps:

Search CMD, right-click the Command Prompt and run as administrator. Then copy and paste the command, click Enter at last: cscript.exe "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" /dstatus

If you are running 32-bit Office on a 64-bit operating system: cscript.exe "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" /dstatus

If you can find the Office product key in list, try to remove it by typing the following command with the Last 5 characters of installed product key (I replace it with XXXXX, but what you type in is what you see on your computer) in this interface: cscript.exe "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" /unpkey:XXXXX

If the 32bit version of Office installed on a 64bit operation, run the following command: cscript.exe "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" /unpkey:XXXXX

Share via

EXCEL dropdown autocomplete function not working when copied to another PC

0 additional answers

Your answer