data validation -- lists keep breaking

PortoMarco

New Member
Joined
Jul 10, 2014
Messages
21
Hi

Each time I create a drop down list through data validation, save my file, close it, re-open: the list breaks.

Why?

Background:

I have independant lists on 4 different tabs. All the lists on these tabs point to a specific column on a fifth tab, which I call "inputs"

Thanks
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
How exactly are you creating the DV lists?
 

PortoMarco

New Member
Joined
Jul 10, 2014
Messages
21
Data - Data Validation

Allow: List
Source: =Inputs!$H$12:$H$24 (example)

This is what I have in =Inputs!$H$12:$H$24

janv-14
févr-14
mars-14
avr-14
mai-14
juin-14
juil-14
août-14
sept-14
oct-14
nov-14
déc-14
YTD

<colgroup><col></colgroup><tbody>
</tbody>
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Is your file an .xls format?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,503
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
That's the problem. You can't have a DV source that refers directly to another sheet in an .xls file. You have to name the range in the other sheet (using Name Manager on the Formulas tab) and then use that name as the source.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,982
Messages
5,526,055
Members
409,681
Latest member
marnu70

This Week's Hot Topics

Top