Power Pivot: Managing Refresh

Power Pivot workbooks need to be refreshed on a schedule. One of the coolest things about Power Pivot is that all that time that users had to spend gathering and scraping data from here, there, and everywhere is how seamless Power Pivot makes it. So why do all of that work to gather all that data to have it be static in your model. I don't know anyone that wakes up every day thinking they just can't wait to get into the office to click that magic refresh button. Fortunately, once you've loaded your Power Pivot workbook into your SharePoint Power Pivot gallery it's easy to manage the day to day refresh schedule.