If AutoFill is not working in Excel, check if it is enabled or not. Thhis article contains some effective solutions that will help you.

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.