Data validation arrows flash and disappear for one user

Asbestos_Jen

Board Regular
Joined
May 12, 2017
Messages
131
Office Version
  1. 2007
Platform
  1. Windows
My spreadsheet was created in Excel 2007. There are data validations in a few places, all referring to named ranges on another sheet in the same workbook. The drop-down arrows are missing only for one user, who has Excel 2010. Other users have 2007, 2010, or 2013. The dropdowns were working prior to having a validation with "indirect" referring to linked pictures of named cells (pick report approver from dropdown, and appropriate signature appears on final report), as shown here: https://www.extendoffice.com/documents/excel/2098-excel-drop-down-list-with-images.html.

Because this is happening only with one user I assume it is something to do with her system or excel settings. Users OS varied, with Win7 and Win10. The problem PC and I are both on Win7. I have been googling for days, and have tried the following with no change:

+ changed the "show/hide objects" setting on the other users' computers (box checked/unchecked/checked).
+ saved the file as .xlsx (original) and .xlsm (though there are no macros in the workbook)
+ saved the file as .xls (broke lots of formulas, but didn't fix anything)

Any thoughts?
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
what do they have in their xlstart / any non standard add ins
 
Upvote 0

Forum statistics

Threads
1,214,653
Messages
6,120,750
Members
448,989
Latest member
mariah3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top