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.

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

Encountering error 400 while running a macro in Excel? This guide will help you with multiple solutions to fix VBA error 400 in Excel.