Anyone know what the code would look like to have a particular field in the pivot's page area default to the last item in the list when the sheet is opened. Ex: Month is an item in the page area. It defaults to: ALL. The user needs to select the latest month each time the sheet is opened. It would be nice if the sheet could open to the latest MONTH in the list by default. Can this be done? What would the code look like? Would I paste it into the View Code area for the tab. THANKS!