+ Reply to Thread
Results 1 to 3 of 3

Data validation won't clear

  1. #1
    Registered User
    Join Date
    11-05-2007
    Posts
    19

    Data validation won't clear

    Hi
    I have data validation in a column range. One cell in this range has the data validation arrows always visible. The arrow positions are slightly off and when I select this cell a second set of arrows appears. I have tried clearing data validation for that cell, closing excel and re-booting, copying the wks to another workbook - nothing works - is this worksheet corrupted?

    Thanks for the help.

    Richard

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    Not sure. Could you have another dropdown or combo box on your sheet? Try Edit > Goto > Special, select Objects and see if anything is selected.

  3. #3
    Registered User
    Join Date
    11-05-2007
    Posts
    19

    Data validation arrows won't clear

    Hi

    I actually solved the problem by saving the file as xml and reopening and saving again as xls.

    Richard

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1