Freeze Panes.

Nigel Martin · Apr 23rd, 2002, 04:37 AM

I know I've only got Excel 97 but I'm having trouble with validation in a cell which works perfectly until Freeze Panes is applied to the worksheet, leaving the validated cell above the Freeze Panes line and NOT working - any ideas ?

Mudface · Apr 23rd, 2002, 04:38 AM

Unfortunately, I believe the only way to stop this is to relocate your freeze point. Have a look at MS support for more details, but I don't think there's a way round it.

gareth · Apr 23rd, 2002, 05:58 AM

If you are freezing the panes from top to bottom it will be a problem when you validate the cell.Solution will be if you havent got any filtering involved in your cell,to move the splitting of the panes further away.It works for me when I was using excel 97 my friend

Have a great day
Ò¿Ó⌐
from Gareth Lombard

Mark W. · Apr 23rd, 2002, 10:26 AM

Quote:

On 2002-04-23 03:37, Nigel Martin wrote:
I know I've only got Excel 97 but I'm having trouble with validation in a cell which works perfectly until Freeze Panes is applied to the worksheet, leaving the validated cell above the Freeze Panes line and NOT working - any ideas ?

Interesting. What's the nature of your validation? When I apply =MOD(A1,2)=0 to cell A1 and freeze panes with B2 selected the validation isn't affected. What's the story?

Mudface · Apr 24th, 2002, 12:58 AM

I think it's probably with the drop-down arrow disappearing when validating with a list, Mark. There's more info here: -

http://support.microsoft.com/default...;en-us;Q236620

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 04:37 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	I know I've only got Excel 97 but I'm having trouble with validation in a cell which works perfectly until Freeze Panes is applied to the worksheet, leaving the validated cell above the Freeze Panes line and NOT working - any ideas ?

Apr 23rd, 2002, 04:38 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Unfortunately, I believe the only way to stop this is to relocate your freeze point. Have a look at MS support for more details, but I don't think there's a way round it.

Apr 23rd, 2002, 05:58 AM	#3
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	If you are freezing the panes from top to bottom it will be a problem when you validate the cell.Solution will be if you havent got any filtering involved in your cell,to move the splitting of the panes further away.It works for me when I was using excel 97 my friend Have a great day Ò¿Ó⌐ from Gareth Lombard

Apr 24th, 2002, 12:58 AM	#5
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	I think it's probably with the drop-down arrow disappearing when validating with a list, Mark. There's more info here: - http://support.microsoft.com/default...;en-us;Q236620