Validation drop-down arrow not showing for SOME users - fine with others?

P

pennie.thomas

Hi

I have a workbook with lots of validation drop-downs, it works fine
for me and some of my colleagues, but some others cannot see the
arrows?

I have sent a mail to ask
*****************************************************
Which version of Excel you are using?

Can you try select one of the cells that should have the list. Then
press Alt-down arrow and see if the list shows up. If so, the
validation is there.

Can you also have a look at Tools>Options, View tab, and if under
'Objects' selected is 'Hide All', the Data Validation arrows won't be
displayed.
*****************************************************

But does anyone else have any other suggestions?
 
B

Bob Phillips

They didn't run some code to delete shapes by any chance?

If so, try this to re-instate 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.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

pennie.thomas

They didn't run some code to delete shapes by any chance?


hi - thanks for getting back to me

they sent back the document and it works on my machine....so urgh -
now also checking that she is in the correct areas...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top