Help request - workbook not working properly on some machines.

Fist off Hello everyone, and Thank you for looking at my question.

I am in an office environment using Excel 2010. We have a few "template" documents that we use built in excel. One of these is a bid recap worksheet that has 10 tabs and a couple basic macros. We copy this document and rename it to finalize a bid for services in our trade. The issue I am seeing is that one of our users is having issues with the document working. This tells me it is a problem specific with his machine and not the document. Here is what happens on his machine.
When to document opens everything works fine except Conditional Formatting, Macro Buttons, and Data Validation cells. The odd thing is that Data Validation drop down cells work on every tab but the first one. What can cause this to happen? I have looked at his settings but I do not see anything amiss, could this be a broken install on his computer? The documents work fine on everyone elses machines. What should I look for to correct the issue?

Hope that gives someone enough info to comment, Thank you for looking.

Originally Posted by davesexcel

Is this a workbook on a shared drive or each workbook is separate on every bodies computer?

The workbook original is on a shared drive and everyone copies it to their own computer to use. I think we have resolved the issue though. The guy having issues with it was running Excel 2007. so compatibility issues I think. We are upgrading him to the 2010 version in hopes that that is the fix.