Good afternoon,

I've created a spreadsheet that has multiple Validated cells. Each of
these cells is validated using a list, with "In-cell Dropdown"
Checked. However the drop down is not showing. The cell is still being
validated as I cannot enter a value other than what is in the list.

Also, on the formula auditing bar, the Trace Precedents, Remove
Precedents, Trace Dependants, Remove Dependants, Remove all arrows and
Trace Error buttons are all greyed out.

I've checked that the sheets and workbook are not protected and as far
as I can tell it has happened between file save from yesterday and
today.

A new workbook does not exhibit these issues, so I'm sure it has
something to do with the file itself.

Am I missing something simple?

Sean

Tools>Options>View

You have Objects"Hide All" checked which will produce your problems.

Pick "Show Placeholders"


Gord Dibben MS Excel MVP

On Fri, 1 Feb 2008 08:33:52 -0800 (PST), Sean Brown <(E-Mail Removed)> wrote:

>Good afternoon,
>
>I've created a spreadsheet that has multiple Validated cells. Each of
>these cells is validated using a list, with "In-cell Dropdown"
>Checked. However the drop down is not showing. The cell is still being
>validated as I cannot enter a value other than what is in the list.
>
>Also, on the formula auditing bar, the Trace Precedents, Remove
>Precedents, Trace Dependants, Remove Dependants, Remove all arrows and
>Trace Error buttons are all greyed out.
>
>I've checked that the sheets and workbook are not protected and as far
>as I can tell it has happened between file save from yesterday and
>today.
>
>A new workbook does not exhibit these issues, so I'm sure it has
>something to do with the file itself.
>
>Am I missing something simple?
>
>Sean

On Feb 1, 4:55*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> Tools>Options>View
>
> You have Objects"Hide All" *checked which will produce your problems.
>
> Pick "Show Placeholders"
>
> Gord Dibben *MS Excel MVP
>
>
>
> On Fri, 1 Feb 2008 08:33:52 -0800 (PST), Sean Brown <seab...@gmail.com> wrote:
> >Good afternoon,
>
> >I've created a spreadsheet that has multiple Validated cells. *Each of
> >these cells is validated using a list, with "In-cell Dropdown"
> >Checked. However the drop down is not showing. The cell is still being
> >validated as I cannot enter a value other than what is in the list.
>
> >Also, *on the formula auditing bar, the Trace Precedents, Remove
> >Precedents, Trace Dependants, Remove Dependants, Remove all arrows and
> >Trace Error buttons are all greyed out.
>
> >I've checked that the sheets and workbook are not protected and as far
> >as I can tell it has happened between file save from yesterday and
> >today.
>
> >A new workbook does not exhibit these issues, so I'm sure it has
> >something to do with the file itself.
>
> >Am I missing something simple?
>
> >Sean- Hide quoted text -
>
> - Show quoted text -

Many thanks.

It's always something simple.