I am creating a pivot table from data in the same workbook but different sheet. once the pivot table is created how do i know where the data is coming from? the sheet and range? this is my students' activity in Excel 2003 (yes, a bit old software) and I am anticipating some of the questions they may ask.