|
In cell drop down button disappeared
I have a column with a data validation list.
My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
If you select the cell and do datavalidation is allow list and in-cell
dropdown still there (and checked)? -- Regards, Peo Sjoblom "lunker55" wrote in message ... I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
Yes they are still there and checked.
joe "Peo Sjoblom" wrote in message ... If you select the cell and do datavalidation is allow list and in-cell dropdown still there (and checked)? -- Regards, Peo Sjoblom "lunker55" wrote in message ... I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
<Tools <Options <View tab,
And under "Objects", *CHECK* - "ShowAll" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "lunker55" wrote in message ... Yes they are still there and checked. joe "Peo Sjoblom" wrote in message ... If you select the cell and do datavalidation is allow list and in-cell dropdown still there (and checked)? -- Regards, Peo Sjoblom "lunker55" wrote in message ... I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
Show all is checked.
Still doesn't work. Is it possible the box is there, but was somehow edited to a sliver in width. Can the size of the drop down be edited at all? Joe "RagDyeR" wrote in message ... <Tools <Options <View tab, And under "Objects", *CHECK* - "ShowAll" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "lunker55" wrote in message ... Yes they are still there and checked. joe "Peo Sjoblom" wrote in message ... If you select the cell and do datavalidation is allow list and in-cell dropdown still there (and checked)? -- Regards, Peo Sjoblom "lunker55" wrote in message ... I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
I created a new file and put in a data validation drop down, and it works,
so I think it is the file itself with the problem-not Excel's settings. Joe "lunker55" wrote in message ... Show all is checked. Still doesn't work. Is it possible the box is there, but was somehow edited to a sliver in width. Can the size of the drop down be edited at all? Joe "RagDyeR" wrote in message ... <Tools <Options <View tab, And under "Objects", *CHECK* - "ShowAll" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "lunker55" wrote in message ... Yes they are still there and checked. joe "Peo Sjoblom" wrote in message ... If you select the cell and do datavalidation is allow list and in-cell dropdown still there (and checked)? -- Regards, Peo Sjoblom "lunker55" wrote in message ... I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
You sure you looked at everything in ToolsOptions?
How about ToolsOptionsViewObjects "hide all"? Checked or unchecked? Gord Dibben Excel MVP On Thu, 24 Feb 2005 11:10:24 -0500, "lunker55" wrote: I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
Hide all is unchecked.
Show all is checked. I think all my options are right because I opened a new file and I can get it to work fine. Joe "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You sure you looked at everything in ToolsOptions? How about ToolsOptionsViewObjects "hide all"? Checked or unchecked? Gord Dibben Excel MVP On Thu, 24 Feb 2005 11:10:24 -0500, "lunker55" wrote: I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
Appreciate the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "lunker55" wrote in message ... I created a new file and put in a data validation drop down, and it works, so I think it is the file itself with the problem-not Excel's settings. Joe "lunker55" wrote in message ... Show all is checked. Still doesn't work. Is it possible the box is there, but was somehow edited to a sliver in width. Can the size of the drop down be edited at all? Joe "RagDyeR" wrote in message ... <Tools <Options <View tab, And under "Objects", *CHECK* - "ShowAll" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "lunker55" wrote in message ... Yes they are still there and checked. joe "Peo Sjoblom" wrote in message ... If you select the cell and do datavalidation is allow list and in-cell dropdown still there (and checked)? -- Regards, Peo Sjoblom "lunker55" wrote in message ... I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
Does anyone else have any ideas??
Joe "lunker55" wrote in message ... Hide all is unchecked. Show all is checked. I think all my options are right because I opened a new file and I can get it to work fine. Joe "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You sure you looked at everything in ToolsOptions? How about ToolsOptionsViewObjects "hide all"? Checked or unchecked? Gord Dibben Excel MVP On Thu, 24 Feb 2005 11:10:24 -0500, "lunker55" wrote: I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 |
There was a problem with xl97 and cells with data|validation that were above the
freeze panes row. But I think the arrow still showed up--it just didn't work. (any chance that you have that configuration). And as a workaround, can you remove the data|validation and add it back? Maybe it'll work there. (or maybe just toggling that in-cell dropdown checkbox. Turn it off, close up the dialog and turn it back on--maybe????) lunker55 wrote: Does anyone else have any ideas?? Joe "lunker55" wrote in message ... Hide all is unchecked. Show all is checked. I think all my options are right because I opened a new file and I can get it to work fine. Joe "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You sure you looked at everything in ToolsOptions? How about ToolsOptionsViewObjects "hide all"? Checked or unchecked? Gord Dibben Excel MVP On Thu, 24 Feb 2005 11:10:24 -0500, "lunker55" wrote: I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 -- Dave Peterson |
"Hi Joe - The workbook has corrupted, and the error repair facility
specifically lists Data Validation as having been lost. What version Excel do you have?" Excel 2003 "File / Open - select workbook - on the 'open' button bottom right on the dialog box you will see a dropdown arrow - click and choose 'open and repair'" Success! Thanks so much Ken, Joe "Debra Dalgleish" wrote in message ... Or maybe a macro was used to clear shapes on the worksheet? Or it could be a corrupted worksheet. Dave Peterson wrote: There was a problem with xl97 and cells with data|validation that were above the freeze panes row. But I think the arrow still showed up--it just didn't work. (any chance that you have that configuration). And as a workaround, can you remove the data|validation and add it back? Maybe it'll work there. (or maybe just toggling that in-cell dropdown checkbox. Turn it off, close up the dialog and turn it back on--maybe????) lunker55 wrote: Does anyone else have any ideas?? Joe "lunker55" wrote in message ... Hide all is unchecked. Show all is checked. I think all my options are right because I opened a new file and I can get it to work fine. Joe "Gord Dibben" <gorddibbATshawDOTca wrote in message m... You sure you looked at everything in ToolsOptions? How about ToolsOptionsViewObjects "hide all"? Checked or unchecked? Gord Dibben Excel MVP On Thu, 24 Feb 2005 11:10:24 -0500, "lunker55" wrote: I have a column with a data validation list. My drop down arrow doesn't show up anymore when I select the cell. It has been working for a year with no problem. Where did it go? I looked in Tools-Options to see if anything was unchecked, but all looks good. Any ideas? Joe Excel 2003 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 03:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com