skip navigation
ED.gov logo U.S. Department of Education Office of Elementary and Secondary Education
About the Reports
Required Excel Settings
User's Guide
Submission Process
FAQs
Get NCES ID#
Help / Contact Us
Home




Required Excel Settings

Download these Instructions: [ Word Version ] [ PDF Version ]

How Do I Enable Macros On My Computer?

You must "ENABLE MACROS" on your computer when working on the Excel forms that you downloaded to complete the Annual Performance Report.

Upon opening the SLCAPR Excel files, most users will see a pop-up window like the example below. When the pop-up window appears, click on the button that says "Enable Macros". All of the files provided have been thoroughly checked for viruses, so that choosing "Enable Macros" will not harm your system.

Excel 97 screen shot of Enable Macros pop up with enable macros button circled

EXCEL 2000 (or higher) USERS

If you are using EXCEL 2000 (or higher) and do not see the "Enable Macros" pop-up window when opening the SLCAPR file, please go to the Excel menu bar and select "Tools" > "Macro" > "Security" as in the example below. When the pop-up box appears, select "Medium Security" and then "OK". Once this is done, open the file again.

Excel 2000 screen shot of menu: tools - macro - security
excel 2000 screen shot of security pop up window with medium selection circled

EXCEL '97 USERS

If you are using EXCEL '97 and do not see the "Enable Macros" pop-up window when opening the file, please go to the Excel menu bar and select "Tools" > "Options" and a pop-up window like the one below will appear. Please make sure you are on the "General" tab. UN-CHECK the box for "Macro Virus Protection" and then click "OK". Once this is done, close the file and then open the file again.

excel 97 screen shot of menu: tools - options

excel 97 screen shot of options pop up window with the general tab selected and the macro virus protection box UNCHECKED

Terms of Use