Problems saving pivot table in same workbook as export query
 

The user exported a query into a workbook, in the same workbook she added a
pivot table worksheet. She saved the workbook but only the export saved. She
needs to know if the pivot table can be saved and refreshed with new data
later on and saved in the same workbook from an export query. Or does it have
to be in a workbook by itself and saved. Please help.