Running a macro

Excel macros let you perform complicated tasks such as manipulating PivotTables…quickly by recording the steps and playing them back when needed.…In this movie, I will show you several ways run your macros so you can pick the…one that works best for you.…I have started with just a blank workbook open and the reason for that is that I…want to show you what can happen if you open a workbook that contains a macro.…To do that, I will trust Ctrl+O to display the Open dialog box and then I will…navigate to my Exercise Files folder, which is on my Desktop, and then under…Chapter 8, I will double-click Running, which is the sample file we will use for this movie.…

When I double-click the file to open it, you might see a security warning bar,…indicating that macros have been disabled.…You then have two options: either to enable the content or to click the Close…button to close the message bar without enabling macros.…In this example I do want to use the macros so in a moment we'll click of the…Enable Content button.…

Resume Transcript Auto-Scroll

Author

Released

4/19/2011

In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.