Share via

Excel Data Validation List - drop down data changes randomly

Anonymous
2014-08-07T16:18:36+00:00

Excel 2013

Hi,

Thanks in advance for your help!  I'm using the Data Validation>List option with Excel 2013.  I have 157 values within my drop down.  From time to time I re-open my file to update a few records and go to the drop down list.  It's then pulling in completely different data which does not apply to my original list. 

I have 4 tabs:  Rough Quote, Proposals, Current, Closed and All clients.  The first 4 tabs share the same drop down list.  The error occurs on different tabs but will not affect all tabs at the same time.  It appears only 1 or max 2 tabs are affected.  

How can I prevent this from happening, or is there something I am doing wrong? 

Thx

Jc

Microsoft 365 and Office | Excel | For home | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2014-08-07T18:35:36+00:00

    I will suggest that you upload your Excel workbook to onedrive and make sure that it doesn't contain any confidential data which violates your organization's policy. If it does contain confidential data, you may look into considering replacing confidential data with dummy data.

    To upload to onedrive -

    1. Login to https://onedrive.live.com/
    2. Open the public folder.
    3. Click Upload in the top.
    4. After uploading, right click it and choose share.
    5. Click Get a Link.
    6. In the option, choose public.
    7. Create Link
    8. Post the link here.

    Was this answer helpful?

    0 comments