Data validation arrows flash and disappear for one user

Asbestos_Jen

Board Regular
Joined
May 12, 2017
Messages
135
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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
what do they have in their xlstart / any non standard add ins
 
Upvote 0

Forum statistics

Threads
1,215,375
Messages
6,124,583
Members
449,174
Latest member
chandan4057

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