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.

Sending Excel files containing crucial financial and business data has risks. To add a layer of protection, you should learn to password protect an Excel file.