On Friday, February 1, 2008 at 12:35:53 PM UTC-5, Sean Brown wrote:

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 <[email protected]> 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.

For some reason, two tabs in the worksheet were grouped together. Right-clicking on the tabs and ungrouping them, enabled the Formula Auditing section.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)