Data Validation Lists go away

A

alankrz

New Member
Joined
Apr 12, 2012
Messages
1
The data validation lists i have in many cells in my spreadsheet disapear when I close excel. When I reopen my spreadsheet the lists will be gone. How do I set up my spreadsheets so the data validation lists always stay.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Hi,

What version of excel are you using?
Could you type the range as written in your data validation?
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Missing Worksheet with Data Validation List Options
Replies
1
Views
118
ajm
A
H
  • Question Question
Help - #unknown! error after adding pictures.
Replies
1
Views
728
myall_blues
myall_blues
drom
  • Question Question
SUMPRODUCT to count dependent validation list column with wrong items
Replies
1
Views
240
drom
drom
B
  • Question Question
Table refresh removes Data Validation value from previous last row and pastes it to newly imported last row
Replies
0
Views
231
bdbilotta
B
D
  • Solved
Data Validation Query - Size of list alters
Replies
1
Views
165
kvsrinivasamurthy
K

Forum statistics

Threads
1,223,264
Messages
6,171,081
Members
452,377
Latest member
bradfordsam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top