In pivot table parameter definition, the third option (Get value from defined/identified cell) is selected. When the file is saved, there are no errors. When the file is re-opened and refresh is triggered, the file will work only if the pivot source is a table in the workbook. If the pivot table data source is direct from MS Query, the defined parameter(s) is/are lost. How can this be avoided?