It sounds like you have macro's disabled. Follow these steps in Excel:
Click the File tab.
Click Options.
Click Trust Center, and then click Trust Center Settings.
In the Trust Center, click Macro Settings.
Select an option that will allow Macros to run.
Click OK.