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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 72:49:19 |
Calls: | 6,489 |
Calls today: | 2 |
Files: | 12,096 |
Messages: | 5,275,833 |