Hi all.
I have a simple excel file that our sales team is using to report on their meetings (I know that's what CRMs are for...we're working on it. this is a temporary stopgap).
I've added a few data validation lists to the file to create consistency for reporting purposes - no formulas, no macros, just text.
They works fine for me, drop-downs appear and if I try to type anything else I get an error message as intended but when it's sent to the sales team, either as a shared file on a network drive or as a local copy on their desktop, some users, not all, can't see the dropdowns.
I'm running Office 2010, and some of the users are on Office 2007. All users are running Windows 7
Am I crazy or is there something I'm missing?
I have a simple excel file that our sales team is using to report on their meetings (I know that's what CRMs are for...we're working on it. this is a temporary stopgap).
I've added a few data validation lists to the file to create consistency for reporting purposes - no formulas, no macros, just text.
They works fine for me, drop-downs appear and if I try to type anything else I get an error message as intended but when it's sent to the sales team, either as a shared file on a network drive or as a local copy on their desktop, some users, not all, can't see the dropdowns.
I'm running Office 2010, and some of the users are on Office 2007. All users are running Windows 7
Am I crazy or is there something I'm missing?
