See Changing the Macro Security Setting in Excel and Enabling Macros for information on what macro settings need to be enabled and how to set them. Many of the features of the program will not operate correctly without macros enabled.