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.

When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

Fix the "Retrieving Data. Wait a Few Seconds" error in Microsoft Excel with these effective solutions, including deactivating browser extensions, clearing cookies ...