I have an worksheet with some PivotTables referring to data in the same worksheet. Sometimes, if the worksheet is moved or send by mail and open on another computer the data scource changes to an absolute path automatically: 'Worksheet!Table' changed to 'Folder[Worksheet.xlsx]Sheet!Table'. If this happens the PivotTable shows no data of course.
Does somebody has an idea how I can prevent this?

Thanks in advance!