Never encountered this problem before.
Have a file, tried to add new rows but it moves the Pivot Table down (like I expect it to) but leaves the data that was in the Pivot Table in the original rows...
Thought something was amiss with the file itself so I created a new file and tried to replicate the file. Same result.
Blank file.
Two headers.
Two rows of information.
The same result.
Anyone know what is going on?
Driving me crazy.
Excel 2013.
Have a file, tried to add new rows but it moves the Pivot Table down (like I expect it to) but leaves the data that was in the Pivot Table in the original rows...
Thought something was amiss with the file itself so I created a new file and tried to replicate the file. Same result.
Blank file.
Two headers.
Two rows of information.
The same result.
Anyone know what is going on?
Driving me crazy.
Excel 2013.