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.

Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...