Excel Challenge regarding Cell Protection/Validation

[Warlocks]

Excel Gurus,

I have an interesting problem whereby a spreadsheet for expenses was created by someone who has since moved on.
What they managed to do was to lock a cell to only accept values between a date range.
I have tried and looked everywhere to find out how he has done this but to no avail. I have even deleted the row that the cell appears on and recreated it but still the validation exists. I have tried changing the "Format Cell" to be of type free text instead. The error returned is as follows:
"Invalid date entered. If you know the date to be correct check your regional settings are set to UK and short date format is set to dd/mm/yy".
I know the problem should not be related to regional settings as the spreadsheet will accept 22/03/05 (22nd March) but will deny 22/04/05 (as the latter date falls outside of the UK Financial Year).

Any help would be most appreciated.

Woody.

 

[SkipVought]

select the cell.

Data/Validation - check to see if there is a validation rule. If so, select the entore column, Data/Validation - and hit the [Clear All] button.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[kpetursson]

Try looking under the "data" Menu for "Validation"
Under the Tab "settings" in the pull down titled "allowed" set to "any value"

Kevin Petursson

 

[Warlocks]

Guys,

I have tried looking at this menu and the Validation option is disabled (greyed out).
Any ideas why?

Woody.

 

[kpetursson]

is sheet protection turned on?

Kevin Petursson

 

[Warlocks]

Turned sheet protection off in order to be able to try and delete a row and re-insert.