See Enabling Macros in Excel 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.