I am trying to create a pivot from a range but keep getting the error
Data source reference is not valid
I have Googled this and tried all of the following.
- Select from Table instead from range.
- Open the Excel spreadsheet click on the view tab and select new window. Save the spreadsheet with a different name for the new window.
- Click on HOME> PREPARE> INSPECT DOCUMENT> Removed all unneccesary references and xml forms.
I have labels on all the columns and all the cells are populated.
I am using Office 2010 on Win7 and the file is in .xlsx format