LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Data Validation has stopped working on one paricular sheet only

Please can someone help. Have been working on quite a complex spreadsheet
and have various sets of drop-down Data Validation cells. These have been
working fine, the other day I saved it then today I went to open it up to do
further edits, the Data Validation cells are now not working, the commands
are still in place but the drop-down arrow has now gone, all other sheets in
the workbook are okay, except this one sheet, if I try and create new Data
Validation commands on this particular worksheet, again, the drop-down arrow
does not display although the command still works, there is no protection
assigned and the setting of this worksheet is the same as all the others in
the workbook, a mystery which I hope someone can help with.
 
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
Data Validation In-Cell Dropdown has Suddenly Stopped being Displa Brett Fish Excel Worksheet Functions 3 April 6th 07 06:32 PM
Edit / Move or copy sheet stopped working in Excel 2003 kris2u Excel Worksheet Functions 0 October 4th 05 08:20 PM
VB Stopped Working [email protected] Excel Worksheet Functions 1 April 28th 05 01:56 PM
excel 97 stopped working john f Excel Worksheet Functions 1 April 13th 05 11:52 PM
In-cell dropdown for validation stopped working Ourbriards Excel Worksheet Functions 3 December 17th 04 09:21 PM


All times are GMT +1. The time now is 05:58 AM.

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

About Us

"It's about Microsoft Excel"