8451

Data Validation Drop Down Box Arrow Disappearing

I have recently been having issues in one of my Excel sheets, I have created a data validation drop down box that refers to a list in an adjacent column (unhidden).

Until today when I clicked on the cell, the drop down arrow appeared but now it briefly flashes before disappearing again, if you click on the right of the cell it still lets you make the selection but other people will use this sheet so it's not really acceptable.

I have checked that the data validation 'In-cell drop down' box is ticked and I don't know where to go from there, has anyone else had this problem? (Google has not been very helpful).

Thank you

Answer1:

I had the same problem and found out that this issue was in my case only related to the speed of the Excel Sheet itself. I had various <strong>linked pictures</strong> in the workbook that made it very slow, resulting as well in the data validation arrow issue.

Removing the linked pictures would improve the performance and resolve the issue.

(Previously I could resolve it with a workaround by creating a macro in "ThisWorkbook" that goes on two sheets and selects the fields with data validation activated when the workbook is launched:

Sheet("1").Range("DataValidation1").Select Sheet("2").Range("DataValidation2").Select

Strange enough, this was sufficient to solve the problem.)

Answer2:

I've never personally seen this but have you tried it on another computer or as another user on your computer? I think it just might be some temp files or cache from office that is causing this issue.

Recommend

  • Always suppress a click event after drag in d3
  • Why is the android emulator starting but then dying immediately?
  • Azure AD B2C Tenant seems corrupted after using AAD Graph Client
  • Intent to Hidden Application on Android
  • C++ on windows 8 closes a program immediately after launching
  • ios - navigationItem.titleView blinks when updated
  • Why is signal.SIGTERM not dealt with properly in my main thread?
  • Making a vectorized numpy function behave like a ufunc
  • Hibernate session.beginTransaction() call and Mysql Start Transaction
  • Rewrite apply function to use recursion instead
  • How Can I Prevent Activation For Some ListView Items When The Selection Mode Is MultiChoiceModal?
  • Quickly or concisely determine the longest string per column in a row-based data collection
  • Does SmartGit support git-svn?
  • Fixed Background Works in Chrome but Not Firefox?
  • Getting IIS6 to play nice with WordPress Pretty Permalinks
  • Responsive Form on top of Responsive Image? - Bootstrap
  • How do I translate LR(1) Parse into a Abstract syntax tree?
  • Separate ID and Class for JS and CSS
  • Select value from xtype selection type checkbox CQ5
  • How to open html table in xls on click of a button
  • CodeIgniter URI Parameter is partially bypassing an “if” statement
  • Flash radiobutton: how do I get the selected radiobutton?
  • For loop with if condition on multiple R functions
  • How can I restyle a word when rendering a pdf with pdf.js?
  • configure: error: no acceptable C compiler found in $PATH
  • Conversion from string “a” to type 'Boolean' is not valid
  • Get history of file changes from TFS to implement custom “blame”-behaviour of exceptions
  • Installing iPhone App to iPhone
  • Abort upload large uploads after reading headers
  • $wpdb not working in file of WordPress plugin
  • How to clear text inside text field when radio button is select
  • Display issues when we change from one jquery mobile page to another in firefox
  • Different response to non-authenticated users and AJAX calls
  • Why ng-show works with ng-repeat but ng-if doesn't? [duplicate]
  • Arrow is showed instead of the material design version hamburger icon. Why doesn't syncState in
  • jquery mobile loadPage not working
  • How do you join a server to an Active Directory (domain)?
  • Can Visual Studio XAML designer handle font family names with spaces as a resource?