Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RS RS is offline
external usenet poster
 
Posts: 113
Default Drop Down List Unavailable

I created 2 drop down list. They have both been working for a month. Today
they are not available. I checked Data Validation, redid the Create process.
Still no drop down list in programed cells. Could I have turned them 'Off'
unintentionally?

TIA
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Drop Down List Unavailable

No harm trying "Open and Repair" (in Excel 2003)
(tip originally 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:22,500 Files:370 Subscribers:66
xdemechanik
---
"RS" wrote:
I created 2 drop down list. They have both been working for a month. Today
they are not available. I checked Data Validation, redid the Create process.
Still no drop down list in programed cells. Could I have turned them 'Off'
unintentionally?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down list dependant on previous drop down list Tenacioushail Excel Discussion (Misc queries) 1 July 1st 08 11:35 AM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
Drop Down List choice selecting another drop down list CVD0722 Excel Worksheet Functions 3 October 31st 06 01:02 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
recently used file list unavailable horst New Users to Excel 2 April 20th 05 02:58 PM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"