I've been having an issue where if I cut and paste a line of data thats being displayed in a pivot table, and paste it in the same worksheet, it works fine. But if I cut it and place it in another separate worksheet, it changes the data range that the pivot table is looking at to a single line, completely undermining the purpose of having it. It does this when the pivot table is in the original worksheet, another worksheet, or is in a separate file.

Anybody else run into this issue and know a workaround?