Editing Prompts in Reports
If the inserted report contains prompts, you can choose to use the default prompts or change them while or after inserting the report.
Note:
When you edit prompts in an inserted report, the report is inserted again as a fresh report in the existing workbook as per the updated prompts. The report sheets with the previous prompts data are not retained in the workbook. If there are changes that you want to keep before editing prompts, save the workbook, as the workbook is regenerated when you edit prompts.