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.