• Data Validation drop down not showing and Formula Auditing bar grey

    From Srinivas Chilakamarri@21:1/5 to Sean Brown on Wed Apr 7 21:37:38 2021
    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 <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.

    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)