ExcelBanter - Data Validation Lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation Lists (https://www.excelbanter.com/excel-worksheet-functions/200895-data-validation-lists.html)

Data Validation Lists

Using Excel 2003, workbook is multi-paged, previous pages have data
validation 'in cell dropdown' lists. One page will not show the 'in cell
dropdown lists'. I believe I've checked everything, tried troublshooting etc.

Any advice

Data Validation Lists

No harm trying "Open and Repair"
(idea from a Bob Phillips' post)

Save as a spare copy, close the file.
Click File Open, navigate to folder,
select the "spare copy" file, then click the arrow dropdown
on the right of the "Open" button choose "Open and Repair"
Good luck !
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"Steve SME" wrote:
Using Excel 2003, workbook is multi-paged, previous pages have data
validation 'in cell dropdown' lists. One page will not show the 'in cell
dropdown lists'. I believe I've checked everything, tried troublshooting etc.

Any advice