Share via

Data Validation Feature not working on Excel

Anonymous
2024-08-28T05:23:36+00:00

Hi,

We've migrated a user from old PC to new PC and some of the Excel files functionalities are not working the same way. Particularly the "Data Validation" feature where a cell on one sheet picks up values from cells from another sheet and creates a drop down and "auto-populate" cell value based on the info.

We replicated multiple Trust Center settings from the Excel app on the old PC to new one but the issue persists.

Can we please receive some help on this?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-29T01:49:42+00:00

    Could you share a test workbook to reproduce your issue?

    For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

    *Please make sure you have removed any sensitive or private information in the sample file before uploading.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-29T00:26:31+00:00

    Hello,

    Thanks for your reply. Find screenshots below, the same settings are saved on the workbook and are working fine on the old PC. Basically when trying to use this functionality on new PC the drop down doesn't auto populate options and user is using multiple large spreadsheets where they use this functionality

    Excel version on new PC (both versions are the same)

    Excel version on old PC

    Thanks,

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-28T06:25:14+00:00

    Could you share some screenshot of your issue and the Excel version you are using?

    File>Account

    Was this answer helpful?

    0 comments