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.

The members of Forbes Business Council offer 15 tried-and-true strategies for identifying what isn't working—and how to replace those processes with more efficient ones.

Troubleshooting the comparison operator Our COUNTIF () setup makes perfect sense, but unfortunately, Excel will reject this function because >L3 isn’t a valid reference.