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.

Read: How to convert currencies in Excel? 4] Review Charts Sometimes, charts can also cause the issue and Excel users can review the charts to verify the cause of formula reference errors in Excel.

Excel may display cryptic errors like #REF or #N/A that make you want to scream. Instead of calling it a day, master these debugging Excel skills to pinpoint the source of errors with laser ...