This will solve all three problems:
Convert your source data to a
Excel 2003 List or Excel 2007 Table.
Give the List (Table) a Defined Name. Include headers.
Enter the Name as the range of the Pivot Table.
Sample file at:
http://www.savefile.com/files/1721155