Automate the Update The next step will create an Auto_Open Macro that will Refresh the XML data automatically when the workbook is opened.   1. Try This: Create a Refresh Macro Go to Developer ->Code. Click on Record Macro. Enter the following when you are prompted: Name: Auto_Open Short Cut Key: Control+Shift+R Click OK to start the recording.   Try This, Too: Record the Steps Go to Developer->XML. Click on Refresh. Go to Developer->Code. Click on Stop Recording.   Keep going...! Exam 77-888: Microsoft Excel Expert 2010 4. Working with Macros and Forms 4.1. Create and manipulate macros. Developer ->Code->Record Macro