Problem with data validation 1

[kragster]

Hi,
About a week ago, something weird happend to one of the spreadsheets that I am continously working on. All the drop down boxes disappeared and now I cant seem to get them back. What I do when I want to make a drop down menu is this: I mark the cell where I want it to make a drop down menu, choose data>validation. In the allow field, I choose "list" and in the source field, I choose the list that contains the specific data. I make sure that the In-cell dropdown option is checked.
This is how I initially created the dropdown boxes, but when I do this now, nothing happens. Has anyone got an idea as to why this suddenly could have stopped working??

 

[xlbo]

Do you have frozen panes anywhere on the worksheet ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

To quote xld ( from the Kingdom of Wessex ), who answered an identical query on another forum:

You probably ran a macro to delete shapes.

Try this to recover them.

Close the workbook (save if necessary).

Then goto File>Open and navigate the file browser to that file (don't select
it from the recent files).

Select the file from the available spreadsheets, don't click Open, but click
the drop-down arrow next to Open and select the Open and Repair option.

This will open it and repair it, fixing the lost validation. You will need
to do a 'SaveAs' on the file, over the top of the previous file if you want,
the repaired file is treated as a new file.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[kragster]

Thanks to both of you. Geoff, I had frozen panes in the spreadsheet but I started by repairing the file and that worked! Thanks a lot.

 

[xlbo]

Frozen panes can often cause Data Validation drop downs to disappear...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[kragster]

Hi Geoff.
Nice to know!
I have another question though: in the same spreadsheet, suddenly a lot of rows are hidden and I can't unhide them. Whats going on when a program suddenly does things on it own?! Any suggestions as to how I can unhide them are much appreciated?

 

[kragster]

Ok I figured it out. Had a user that put a filter on the table and didn't remove it before he saved. Thats why the table seemed to have hidden rows, but actually just was filtered You learn new things every day.

 

[GlennUK]

Hi kragster,

select all rows and do menu command Format/Row/Unhide, and see if that works.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

Oops, that'll teach me to be slow on pressing the Submit button. Glad you sorted it.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[kragster]

Yeah well slow as you are, you deserve credit for trying to help me

 

[GlennUK]

ha ha, thanks. It's nice to be appreciated. :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.