Cell Validation

[Simon Shaw]

Hi,

My cell validation does not appear to be working when the calculate takes
time. My sheet can take upto 30 seconds to calculate, but when I type a value
into a validated cell, I am not getting a message that the the entry is
invalid...

I have removed the validation and re-set it up... no luck...

thoughts?

Simon

[Jim Rech]

Never heard of this. It sounds as if you have calculate set to Automatic.
I don't suppose setting it to Manual helps?

--
Jim Rech
Excel MVP
"Simon Shaw" <[email protected]> wrote in message
news:[email protected]...
| Hi,
|
| My cell validation does not appear to be working when the calculate takes
| time. My sheet can take upto 30 seconds to calculate, but when I type a
value
| into a validated cell, I am not getting a message that the the entry is
| invalid...
|
| I have removed the validation and re-set it up... no luck...
|
| thoughts?
|
| Simon

[Gord Dibben]

Simon

For the validation part.........

Do you have, on the Error Tab, "show error alert when invalid data entered"
checked?

For the calculation part see Jim's response.


Gord Dibben Excel MVP


On Wed, 23 Feb 2005 19:51:01 -0800, "Simon Shaw"
<[email protected]> wrote:

>Hi,
>
>My cell validation does not appear to be working when the calculate takes
>time. My sheet can take upto 30 seconds to calculate, but when I type a value
>into a validated cell, I am not getting a message that the the entry is
>invalid...
>
>I have removed the validation and re-set it up... no luck...
>
>thoughts?
>
>Simon

[Simon Shaw]

Hi Gord and Jim,

I set Cacluation to Manual, no luck... and yes it is checked on the error
tab and set to Stop.

can I send someone the sheet to have a look?

Simon

"Gord Dibben" wrote:

> Simon
>
> For the validation part.........
>
> Do you have, on the Error Tab, "show error alert when invalid data entered"
> checked?
>
> For the calculation part see Jim's response.
>
>
> Gord Dibben Excel MVP
>
>
> On Wed, 23 Feb 2005 19:51:01 -0800, "Simon Shaw"
> <[email protected]> wrote:
>
> >Hi,
> >
> >My cell validation does not appear to be working when the calculate takes
> >time. My sheet can take upto 30 seconds to calculate, but when I type a value
> >into a validated cell, I am not getting a message that the the entry is
> >invalid...
> >
> >I have removed the validation and re-set it up... no luck...
> >
> >thoughts?
> >
> >Simon
>
>

[Gord Dibben]

Simon

Send it on to me via email, not this group.

Change the AT and DOT for my email address.


Gord

On Mon, 28 Feb 2005 17:53:01 -0800, "Simon Shaw"
<[email protected]> wrote:

>Hi Gord and Jim,
>
>I set Cacluation to Manual, no luck... and yes it is checked on the error
>tab and set to Stop.
>
>can I send someone the sheet to have a look?
>
>Simon
>
>"Gord Dibben" wrote:
>
>> Simon
>>
>> For the validation part.........
>>
>> Do you have, on the Error Tab, "show error alert when invalid data entered"
>> checked?
>>
>> For the calculation part see Jim's response.
>>
>>
>> Gord Dibben Excel MVP
>>
>>
>> On Wed, 23 Feb 2005 19:51:01 -0800, "Simon Shaw"
>> <[email protected]> wrote:
>>
>> >Hi,
>> >
>> >My cell validation does not appear to be working when the calculate takes
>> >time. My sheet can take upto 30 seconds to calculate, but when I type a value
>> >into a validated cell, I am not getting a message that the the entry is
>> >invalid...
>> >
>> >I have removed the validation and re-set it up... no luck...
>> >
>> >thoughts?
>> >
>> >Simon
>>
>>

[Gord Dibben]

For follow up to this post and its resolution.

The DV lists had a great whack of blanks.

Unchecking "Ignore Blanks" resolved the issue of entering invalid data and
getting no error message.


Gord

On Tue, 01 Mar 2005 09:16:58 -0800, Gord Dibben <gorddibbATshawDOTca> wrote:

>Simon
>
>Send it on to me via email, not this group.
>
>Change the AT and DOT for my email address.
>
>
>Gord
>
>On Mon, 28 Feb 2005 17:53:01 -0800, "Simon Shaw"
><[email protected]> wrote:
>
>>Hi Gord and Jim,
>>
>>I set Cacluation to Manual, no luck... and yes it is checked on the error
>>tab and set to Stop.
>>
>>can I send someone the sheet to have a look?
>>
>>Simon
>>
>>"Gord Dibben" wrote:
>>
>>> Simon
>>>
>>> For the validation part.........
>>>
>>> Do you have, on the Error Tab, "show error alert when invalid data entered"
>>> checked?
>>>
>>> For the calculation part see Jim's response.
>>>
>>>
>>> Gord Dibben Excel MVP
>>>
>>>
>>> On Wed, 23 Feb 2005 19:51:01 -0800, "Simon Shaw"
>>> <[email protected]> wrote:
>>>
>>> >Hi,
>>> >
>>> >My cell validation does not appear to be working when the calculate takes
>>> >time. My sheet can take upto 30 seconds to calculate, but when I type a value
>>> >into a validated cell, I am not getting a message that the the entry is
>>> >invalid...
>>> >
>>> >I have removed the validation and re-set it up... no luck...
>>> >
>>> >thoughts?
>>> >
>>> >Simon
>>>
>>>