I do not have Office 2007 any more, but I believe it is the same as 2010... You make the change in the connection properites. You will want to go to the Pivot Table tab > Change Data Source > Connection Properties > Usage Tab... Change the maximum number of records to retrieve option from 1000.