If you have are trying to create a pivot table and are getting the error “Data source reference not valid” ?It’s ususally caused by excel sheets with square brackets in the title [ remove these and it should work fine]
Typically replies within a day