NCLB Annual Financial Report Files
2009-2010 User Guide
WARNING: prior to opening the Annual Financial Report files, please close all other M/S Excel files you may have open.
Go to the NCLB - No Child Left Behind table of contents under Fiscal Year 2009-2010, Annual Financial Report files.
Right Click on the Appropriate Annual Financial Report file.
Choose the "Save Target As" option from the pop-up box. The File Download screen will appear. Enter the directory path on your hard drive or network drive where you would like the Annual Financial Report file stored and click OK.
WARNING: prior to opening this M/S Excel file, please close all other M/S Excel files you may have open.
After downloading and saving the Excel file, open it up by double-clicking on the file name or go into Excel from the Start-Programs-Microsoft Excel route and then open the file (File-Open). Each time you open the file you will see a screen which asks if you want to enable macros. The correct response is Enable Macros. ****If you are working with Excel 2007, the Edit Configuration Box may not open, even when you select it. If this happens, look for the bar above the above the AFR file that says "Security Warning". Click on the "Options" box to the right of the Security Warning. Choose the option that says "Enable this Content". The Edit Configuration box should then open.***** Macros are embedded computer programs which perform tasks for you. In this Excel file, the macro will help you select the appropriate options you will need to complete in order to email the file back to CDE after you have finished your data input to the file. You will notice sheets being hidden and unhidden by the macro based on your selections made on the 2a - cover page sheet, this is normal.
For more information, contact:
Barb Vassis: Grants Fiscal Management Services, (303) 866-6389 vassis_b@cde.state.co.us
Robert Hawkins: Grants Fiscal Management Services, (303) 866-6775 hawkins_r@cde.state.co.us
Debbie Wolfe: Grants Fiscal Management Services, (303) 866-6724 Wolfe_d@cde.state.co.us