Data validation and Freeze Panes

R

rob nobel

Hi,
I have some cells with data validation with In-cell dropdown selected.
I notice that on a laptop with windowsXP/office 97, that the validation
dropdown does not operate for any cells with this style of validation ABOVE
the freeze pane section, although it does on a desktop PC with office 2000 .
The validation dropdown works fine BELOW the window freeze pane section.
Just not ABOVE..
Any help here?
Rob
 
C

Chip Pearson

Rob,

It is a known bug in Excel 97. There is no fix for it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
R

rob nobel

AAAHHHH!!!
But thanks Chip
Rob

Chip Pearson said:
Rob,

It is a known bug in Excel 97. There is no fix for it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

2000
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Error 1
Freeze Panes , Data Validation Conflict 2
Data Validation Dropdown List Not Working 4
2007 data validation not working 1
Data validation dropdown arrow disappeared 2
Data Validation Dropdown 1
Edit Data Validation 2003 18
Validation above the Freeze Line 4

Top