I don't think you need to turn the pivot table back into a flat file. The flat file exists elsewhere. Look on another sheet (or maybe it is pulling data from a DB) for the data source.