My boss is trying to fill out an excel spreadsheet Using Excel 2010. We can see the down arrows but when you click it nothing happens. I forwarded the file to myself also using excel 2010 and it works fine. I have disabled his add-ins and have had no luck. I also did a side by side comparison of our settings and they are identical.

Just wanted to provide the resolution to this issue that I had. Hopefully this will help others that might run into this when migrating file servers from server 2003 to server 2012 r2.

I opened up a ticket with microsoft support. After 3 days of trying different settings, adding / flipping registry keys on and off, rebooting servers and clients, we decided to use a microsoft tool to batch convert all excel 2003 spreadsheets to the excel 2013 format.

Software Used = Office Migration Planning Manager (OMPM) 2010﻿. Below are the links to the software, office compatibility and documentation. I installed this on a windows 7 pc and ran the conversions locally. I then copied them up to the server and made the users a backup folder with the old spreadsheets in case formulas or formatting were lost during batch conversion.