I know you can create a pivot table and get multiple views by manually changing the field at the top. For example to see a particular County instead of the entire service area. In prior versions, I was able to automatically (have excel perfor this for me) create multiple worksheets based on that Pivot Table field, but I can't seem to do it in Excel 2007. Is it no longer part of the functionality? I think this is a regular feature of Excel, so should be an easy one if someone can point me in the right direction.