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.

If you see Error Bookmark Not defined or Error Reference source not found in Word, then use the solutions mentioned in this post to fix the issue.