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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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

H
  • Question
Help - #unknown! error after adding pictures.
Replies
1
Views
103
myall_blues
myall_blues
drom
  • Question
SUMPRODUCT to count dependent validation list column with wrong items
Replies
1
Views
152
drom
drom
B
  • Question
Table refresh removes Data Validation value from previous last row and pastes it to newly imported last row
Replies
0
Views
102
bdbilotta
B
K
  • Question
Select the Name in the Data Validation list on a cell value then the same name run the sub macro
Replies
6
Views
121
DanteAmor
DanteAmor
M
  • Question
Data Validation using VBA and Excel function
Replies
0
Views
147
ManUBlueJay
M

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

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