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

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" wrote in message
...
| 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

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"
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

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"
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

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"
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"
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

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"
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"
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