PQ needs an excel table to my knowledge (which is limited about PQ). there are articles on the web about using named ranges, but as a quick win could you just recreate (copy & paste linked data?) the data on another sheet and use that one for your the PQ and then extend the table manually as you add data to the non excel table?



Not great but might help until you can find a better fix