Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

PivotTable Wizard

2. Where is your data?
If you selected the entire OriginalData spreadsheet, this is how Excel maps the location of the Table or Range: OriginalData!$A:$K

 

In words, that means "name of your spreadsheet" ! "all of the data in Column A through Column K."

 

Where do you want to work on the new PivotTable report?

The logical choice is to create a new PivotTable in a new worksheet.

Insert ->PivotTable