Confirm the range encompasses the data you want to use in your pivot table. Choose whether to insert the table on a new sheet or in the current one. Select New sheet to make a cleaner presentation.

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.