Recently I was trying to create the Pivot table in excel but however, whenever I try I get the error message 'data source reference is not valid'. Can someone tell me how to resolve this error while creating a pivot table in excel.
Recently I was trying to create the Pivot table in excel but however, whenever I try I get the error message 'data source reference is not valid'. Can someone tell me how to resolve this error while creating a pivot table in excel.
According to my information you are missing something for the creation of this Pivot table in the Excel, so you should have to follow the Steps for the creation of the Pivot Table. May this link will help you out.
How to create a Pivot Table report
Bookmarks